- Posts: 6
- Thank you received: 0
excel vba form
15 years 7 months ago #1058
by wheefus
excel vba form was created by wheefus
hi
i have created an excel vba form and want any data entered on it to appear on an excel page how do i do this e.g. a from date and a to date entered on vba form to appear on a excel work sheet
and if a date is entered in a cell it will appear on the form how to do this i think that would be quicker for me
any help
i have created an excel vba form and want any data entered on it to appear on an excel page how do i do this e.g. a from date and a to date entered on vba form to appear on a excel work sheet
and if a date is entered in a cell it will appear on the form how to do this i think that would be quicker for me
any help
Please Log in or Create an account to join the conversation.
15 years 7 months ago #1061
by Pete
DigiOz Webmaster
www.digioz.com
Replied by Pete on topic excel vba form
Hi,
You can use the following to set the value of a form textbox to the current active cell:
Alternatively, you can offset X number of cells around the current active cell and set the value that way. For example:
Pete
You can use the following to set the value of a form textbox to the current active cell:
Code:
ActiveCell.Value = txtTextBoxName.Value
Alternatively, you can offset X number of cells around the current active cell and set the value that way. For example:
Code:
ActiveCell.Offset(0, 1) = txtTextBoxName.Value
Pete
DigiOz Webmaster
www.digioz.com
Please Log in or Create an account to join the conversation.
Time to create page: 0.119 seconds