excel vba form

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

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