View Full Version : VBA - help assigning varibles

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?

03-13-2017, 12:03 AM
Could you attach a small workbook with what you have? I am not grasping exactly how you are assigning the input box to the button.

03-13-2017, 02:39 AM
That reads like cmdButton is your variable.