So I am using the
to get some values from the user and most of them go to certain cells on my worksheet. However, there is one particular value (a dollar amount) that I do not want to store, but use later on to compare against a different value.
I tried declaring a public variable x and putting the value like
but that doesn't work, I guess since its a Private sub.
Any help appreciated!
Code:
Private Sub CommandButton1_Click()
I tried declaring a public variable x and putting the value like
Code:
x=textbox10.value
Any help appreciated!