Edit a selected Combobox with another userform

**clapforthewolfman** · 08-01-2013, 04:07 PM

Hi all looking for some help with VBA code...

Basically this is my issue: I have userform and with comboboxes. I have it set so that when you select "Other" in the "cmboProjectType" combobox another userform opens with the code below. What I want is to make this userform less specific. So instead of editing the "cmboProjectType" value exclusively it woul edit any combobox where the cursor is currently ( I wish to apply the add other value UserForm across multiple UserForms in my Workbook rather than making a userform for each combobox).

I'm sure this can be done but I am not sure how. Any help would be greatly appreciated!

Thanks,

Wolfman

Please Login or Register  to view this content.

**Andy Pope** · 08-02-2013, 04:20 AM

rather than push the information to a specific combobox, as in the cmdOtherValueOK event, alter you code to pull the information from the txtOther. The code would need to be where the userform is currently being launched from. Also the cmdOtherCancel event should then only Hide the userform. This will allow you to read the information before unloading the userform