text box input to store as a variable?

Originally Posted by losmi8

I have a simple (I think) question. I drew a TextBox in my excel sheet, and I would like that after I enter something into it, lets say for ex "59"...I'd like for that text to be then stored as a variable ("number").

Then I'd like to perform some calculations with that variable. For instance:

Range("A1").Value = 14 + number


and I would like A1 to then show 73 ((14 + 59 (or whatever was entered into the text box))

Is this possible?

Please Login or Register  to view this content.

Hi losmi8
This code is similar to jrdnoland's

Please Login or Register  to view this content.

.
I've assumed your "14" was from another location ("C1") in the code; the code also clears TextBox1 when you tab out of TextBox1 (the tab key actually fires the code).
Hope this helps. John

Hi losmi8
This code will pass the value of TextBox1 (x) to procedures in the same module.

Please Login or Register  to view this content.

Hope this helps. John

Hi losmi8
I should have explained that

This code will pass the value of TextBox1 (x) to procedures in the same module

and will remain available in the module until an End statement is executed.
John