Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA Assistance
I swear to god, nothing could be more oblique than the help you get by
pressing F1 while trying to program in VBA/excel. I am trying to make a simple form that will populate cells with data, both numerical and text, that is entered into a text box on the form. I would also like one of the text boxes to perform a calculation using dumbers entered into the other text boxes, and record the result to a cell on the spreadsheet. Additionally I would like the form to advance to the next row when it tabs back to the first text box. This used to be very easy in visual basic, and now seems impossible using vba and the help files are no help at all. Can anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA Assistance
The below link by Debra Dalgleish should belp...
http://www.contextures.com/xlUserForm01.html If this post helps click Yes --------------- Jacob Skaria "Elcobar" wrote: I swear to god, nothing could be more oblique than the help you get by pressing F1 while trying to program in VBA/excel. I am trying to make a simple form that will populate cells with data, both numerical and text, that is entered into a text box on the form. I would also like one of the text boxes to perform a calculation using dumbers entered into the other text boxes, and record the result to a cell on the spreadsheet. Additionally I would like the form to advance to the next row when it tabs back to the first text box. This used to be very easy in visual basic, and now seems impossible using vba and the help files are no help at all. Can anyone help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA Assistance
Debra Dalgleish has some instructions he
http://contextures.com/xlUserForm01.html http://contextures.com/xlUserForm02.html and http://contextures.com/xlVideos05.html#UserForm01 http://contextures.com/xlVideos015html#UserForm01 Elcobar wrote: I swear to god, nothing could be more oblique than the help you get by pressing F1 while trying to program in VBA/excel. I am trying to make a simple form that will populate cells with data, both numerical and text, that is entered into a text box on the form. I would also like one of the text boxes to perform a calculation using dumbers entered into the other text boxes, and record the result to a cell on the spreadsheet. Additionally I would like the form to advance to the next row when it tabs back to the first text box. This used to be very easy in visual basic, and now seems impossible using vba and the help files are no help at all. Can anyone help? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum and If Assistance Please | Excel Worksheet Functions | |||
Assistance please | Excel Worksheet Functions | |||
If Then assistance... | Excel Worksheet Functions | |||
Need some assistance | Excel Worksheet Functions | |||
Assistance please? | Excel Worksheet Functions |