Search results

I don't know why it didn;t occur to me to use the IF function....that is the ideal solution. Thank you both.

Hi everyone, I have made a new years resolution to keep track of my finances. What better way to leverage Excel and it's capabilities with VBA?? I am able to download account activity into csv files from my banking website. I am writing vba to take the raw extract file and format it to my...

Happy New Year! b) Each time WARNING is selected, open a new word file (with Notice1, Notice2, etc. as filename). If a selection is changed from WARNING to something else, nothing should happen. If WARNING is selected, deselected, then selected again, two word documents should be created for...

a) one Word document for each trigger. Filename= Notice1, Notice2...etc b) each time a WARNING!! triggers in column A, a Word document is created. If it is possible, I would prefer that multiple documents be created side-by-side....so if I selected WARNING!! in rows 2, 6&7 of column A, Notice1...

I have been able to incorporate a table within the word document that is created, but I am struggling with the formatting of the table. I tried to set the row height to 0.15 and the text to be vertically aligned in the middle of the table cells, but neither of these two arguments seem to work...

Correct. It was created initially to export to PDF but I now think it will be more effective to have it export to Word so it is in a format that can be easily added to/edited. Thanks for your help Sir!

Sorry, I was too lazy. Here is a dummy file that should sufficiently explain what I am doing and what remains incomplete.

Hi, I am using a trigger event to create a word document which pulls information from the target.row that initiated the trigger event. I can get most of this done, but it gets tricky when I want to put some of the variables I define into a Word table. To clarify, I want to create a new table in...

Would this be an Admin-only privilege? I am not very savvy with SharePoint and cannot seem to find this feature.

Does anyone know how this can be accomplished? When I use "Save and Send" in Excel and save a shared workbook to Sharepoint, I get the following error message: Unable to Load Workbook The workbook that you selected cannot be loaded because it contains the following features that are not...

Hi everyone, I have created a file that I would like to share on Sharepoint 2007. I have selected the Share Workbook option within the excel file, but every time I try and have multiple users open the file, the excel file opens as Read-Only ("This workbook was opened from a server in read-only...

Nailed it! Thanks so much to all for helping!! Have a great weekend.

Hi Narayan, Userform1 is displayed when "Yes" is selected in rows 7,12,17,22...to 92. Userform2 is displayed when "No" is selected in rows 5,10,15,20...to 90. Below is the code which Lohith supplied that worked great for a single userform. I have tried to modify it so it accomodates the...

of course. thanks for taking the time to help

That's correct. As per lohith's suggestion, all comboboxes are now replaced with vba. Here is a link to the file. https://www.dropbox.com/s/plxp653t3512cte/slow%20file%20demo_v3.xlsm thanks!

Lohith (or whomever is gracious enough to help!), I have taken my first stab at revising the code to work with data validation cells instead of combo boxes. I can tell that the code runs but it fails to show the userform. Please advise as to how to proceed with this revision. I apologize for...

Correct me if I am wrong but I am trying this out in the Worksheet_Change procedure. I am not sure how to reference the data validation lists so that when "No" is selected in rows 5,10,15...etc Userform2 shows and when "Yes" is selected in rows 7,12,17...etc Userform 1 shows. I am thinking...

Lohith, I did not think I could perform the same with data validation...I am very interested in pursuing this option now. Will I need to tie the code to the Worksheet_Change procedure?

Thanks to you both...all I needed to do was remove that one line of code that was in the "ThisWorkbook" module. Now the ComboBox values are retained when closing/re-opening. So now I have gotten to the point of completion for this file (in terms of vba/functionality). The only downside is it...

I was able to resolve this issue by building off of the demo workbook you uploaded instead of trying to recreate another file from scratch... The only issue remaining is that whenever I close and re-open the file, all the ComboBoxes are reset to blank. I started another thread (sorry if this...

Hi, I have a workbook with lots of ComboBoxes. They are all "Yes/No". When I save & close and then re-open the workbook, the ComboBoxes that previously had "Yes" or "No" values selected are now reset to blank. How can I retain the values in the ComboBoxes that have been changed so that the...

So despite my less-than-full understanding of the code, I have (more or less) adapted the code to fit my working file with 456 comboboxes. I would really appreciate some help with the following: Often when I start with the first "Notes" combobox (in cell B5), it will run the userform and the...

Thanks Narayan. Since I am expanding this code to allow for 19 total questions, with everything else remaining constant, would this piece of code be the only piece that I need to change? (I have added to the arrays): lookup_array = Array(0, 17, 25, 41, 49, 65, 73, 89, 97, 113...

Narayan, I checked the file, and I noticed one issue: The comboboxes under Delaware (column I) get pasted into column A of the 'Notes' sheet....instead of column I. Other than that it works great! The file that I will be applying this code to will have the same number of columns but a...

Narayan, Thats exactly it....thank you very much!!!