excel vba form

More
15 years 1 month 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

Please Log in or Create an account to join the conversation.

More
15 years 1 month ago #1061 by Pete
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:
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.115 seconds
Powered by Kunena Forum