ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   VBA Assistance (https://www.excelbanter.com/excel-discussion-misc-queries/233820-vba-assistance.html)

Elcobar

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?

Jacob Skaria

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?


Dave Peterson

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


All times are GMT +1. The time now is 03:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com