how do I return the value from the userform (Client_Value) into the module?
Please Login or Register to view this content.
how do I return the value from the userform (Client_Value) into the module?
Please Login or Register to view this content.
Your question is not very clear.
What module are you talking about? Do you have other code where the userform is shown?
Yes, Module 1 has
I need the combobox to return the selection as a Variant or String in a Macro contained Module1 so that I can use it in a string, vlookup, and enter the data into a cell. I want to do this without putting the value into the cell and having the Macro contained in Module1 reading it from the cell, if possiblePlease Login or Register to view this content.
userform code
macro codePlease Login or Register to view this content.
Please Login or Register to view this content.
I am getting a Run-Time Error '70': Permission Denied
Which line exactly?
Is your combo box linked to a range? Delete the combo populate line if so.
Yes it was linked to a range.Please Login or Register to view this content.
This worked. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks