Asked By
Morse
230 points
N/A
Posted on - 05/16/2011
Hi,
I am doing some work with Excel. I am not much familiar with VB but the Excel macro seems easy and interesting. I have yet used MsgBox and buttons to do almost everything. The Excel sheet was the main window which is used as a form for hosting the other stuffs.
For example if i need 3 data to input I use something like
x = InputBox("enter the value", "Its the title")
3 times.
Now I think it would be cool to have my custom popup messages/forms for doing all these. But how do I do this? Please help.
How to create a custom Popup form in Excel
That was a pretty clean solution by Simmy.
If the toolbox doesn’t show up go to view toolbox.  And yes no matter what you add in the form, give the form (itself) a good relevant name like "datainput". You have to use to show the form.
Answered By
Morse
230 points
N/A
#97804
How to create a custom Popup form in Excel
Thanks for the sharp reply.
I have made the form as you said. The name of the form is "datainputform". The three fields are
Now what?
How to create a custom Popup form in Excel
Giving the text field name "Name" may conflict with other attribute. Name is also a attribute . So instead of "name" give it "NameField"
When done, double click the button in the form and do your calculation there. You can access the value in the 3 fields by:
-
NameField.Text
-
ID.Text
-
Payment.Text
Hope this helps.
How to create a custom Popup form in Excel
Simmy is right. And yes, when you are done with the form, you have to add this:
datainputform.Show
Wherever you want this form to be shown.
Answered By
Morse
230 points
N/A
#97809
How to create a custom Popup form in Excel
Yeppy. Â Thanks both of you.
