At the moment I have inserted VBA code into my spreadsheet to allow for clicks of the mouse to add or remove colour. When I try to insert code, in combination with my own code, to protect certain cells or use unlocked/locked functions it will not work. I need somebody to write some code that will allow me to still protect certain cells and click to
I am looking for an Excel and VBA expert to create a spreadsheet capable of generating lists of names. For example, out of 8 names, I want a list created by choosing only 3 names at a time - which should produce a list totaling 56 combinations. It is a "n choose k" combination problem without replacement where order is not important. For the list,
The pdf created through itextpdf is to have a return button or a hyperlink to return back to the original page. The code should run on google app engine. The attached image shows a prototype of a return button/hyperlink.
...Commerce inventory files through their API. Because I need to be able to tweak this over time, I need this to work within Excel 2007 VBA. I have done this in the past using web tools ([url removed, login to view]) with success. Specifically I need to be able to update the Products Fields: [url removed, login to view]
Attached is a tiny c# project - it amounts to less than 50 functional lines. It logs on to an Azure web service, sends a request and receives a number. I would like an excel spreadsheet with vba code to do the same.
...“COPY” button: ALL the selected text will be summarized on screen with 1 space “ “ in between each word. ALL the selected text will be automatically “copied” to computer’s clipboard with 1 space “ “ in between each word. The user will then go to another program and “paste” the text. User will return to script and...
VBA project, automating population of word documents (test sheets) from excel with multiple versions of office. Existing system struggles with different versions of Microsoft Word Object Library. Also needs to be easily expandable for new and different test sheets. Test sheets are a controlled document which sit on a server in a separate folder to
...haben eine Kalkulations- sowie eine Angebotserstellungs- und Rechnungserstellungstabelle im Excel erstellt. Es gibt ein paar Details, die wir gerne ändern möchten. Hierzu sind VBA Kenntnisse erforderlich, die wir in der Firma nicht haben. ...
...would like to create a simple form, that has the following - Drop Down Cells (DATE - CATEGORY - SUBCATEGORY - CURRENCY) - OPEN cells for text (AMOUNT - NOTE) - then the button OKAY / SEND / ACCEPT Once i go through the drop downs, selecting date, and category ie. HOUSE, then sub, ie. LAUNDRY, and currency, then i entered the amound 10 and USD
Simple project. I need it to process all xls files in the directory, one by one. Directory is selectable the worksheet in all files is Sheet1 Select the date with datepicker format M/D/YYYY, this date goes in cell B8 Select week 1-5 are drop down selections. The 3 choices are Pending Holiday - When it saves the files it will create a new directory called Completed and save the f...
[url removed, login to view] Right side facebook page like box displayed. When click on like button then it redirect to 404 not found page. Give me solution for that. I Think facebook page like button code is wrong. Let me more dicuss into PM box
Preciso de um orçamento para a construção de um sistema WEB (preferencialmente) ou VBA (alternativamente). O sistema deverá ser acessado pela internet, porém deverá funcionar como se fosse uma intranet, permitindo somente o acesso de usuários logados com login/senha. O login poderá ser integrado com facebook/google/microsoft. ...
I am looking to be able to extract Google calendar information into Excel. In the code, I would like to specify the following: 1. Login information 2. From date 3. To Date The information I need back from the calendar is the following table: 1. Date 2. From Time 3. To Time (or duration) 4. Title 5. List of guests.
vba/ macro auto create tab, dropdown and sheet based on data. i have excel file, i would like to create macro/vba to refresh/create tab, dropdown, sheet based on 1 tab called data1. let me know if i can call to make it eaier to explain
...making the areas for Radio Button Options and Check Box Options expandable and collapsible to save space. Here’s a summary of the what the updated version should include… Radio Button Option #1 (with up to 25 radio buttons selections) Radio Button Option #2 (with up to 25 radio buttons selections) Radio Button Option #3 (with up to 25 radio