sampson
03-12-2017, 11:18 PM
I very familiar with assigning variables to inputboxes, but I have a new situation for me and I'm stumped.
I have a workbook with a command button that activates an inputbox. In order to do this I've said:
cmdButton = Inputbox(blah blah blah)
This way when the button is pressed, the Inputbox opens. However, having the cmdButton attached to the Inputbox removes my ability to now assign some usable variable. How do I now store the Inputbox's user entered value into a variable?
I have a workbook with a command button that activates an inputbox. In order to do this I've said:
cmdButton = Inputbox(blah blah blah)
This way when the button is pressed, the Inputbox opens. However, having the cmdButton attached to the Inputbox removes my ability to now assign some usable variable. How do I now store the Inputbox's user entered value into a variable?