billyshears
Board Regular
- Joined
- Aug 29, 2013
- Messages
- 61
I have a userform setup that allows me to type a value into one of 5 different text boxes.
When I hit the command button, the value in Cell A1 should be changed by the value I type into one of the text boxes.
I know how to code the value being changed if I only have one box, but now that I several boxes, do I need an if statement here? If Box1=0, then grab value from Box2, if Box1 and Box2 = 0, then box 3 type of thing?
Thank you in advance
When I hit the command button, the value in Cell A1 should be changed by the value I type into one of the text boxes.
I know how to code the value being changed if I only have one box, but now that I several boxes, do I need an if statement here? If Box1=0, then grab value from Box2, if Box1 and Box2 = 0, then box 3 type of thing?
Thank you in advance