Text Box to Cells

[vioravis]

I have attached an excel file with an example of what I am trying to do. "Enter Input" pushbutton on "Data Sheet" worksheet prompts a user form. I would like the user to enter a value or choose a default value of 100. If he chooses the default value, I would like that value to appear on the text box before the user confirms it by pressing OK button. Whatever the value is entered in the text box must be displayed in the yellow cell in the worksheet named "Input Summary". Can someone please help me how I can do it? Thank you.

[Trebor76]

Hi there,

Instead of a user form, look at the attached where I've used an Input Box to achieve the same.

HTH

Robert

[vioravis]

Trebor76,

Thanks for the reply. I see a problem with this approach. I need to have more than one input box in the same user with unique labels for each one of them. Can I use your method to have multiple input boxes in the same userform? I also want to have a separate pushbutton for default.Thanks.

[boylejob]

vioravis,

See if this does what you are wanting.

Put code on your UserForm

Please Login or Register  to view this content.

Put this in the module

Please Login or Register  to view this content.

[vioravis]

Thanks, jeff. This works fine. Is there an efficient way to do it if I have such 20 different userforms with each userform having 10-20 input boxes?

[boylejob]

vioravis,

That is a pretty broad question. 20 UserForms with 10-20 input boxes has the potential for a lot of variables going in a lot of different directions.

Can you explain your situation a little further. There might be a simple efficient way of handling your situation, but we need to know more about what exactly you are wanting to do.