ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Forms (https://www.excelbanter.com/excel-discussion-misc-queries/249080-forms.html)

MarkOffice2007

Forms
 
I have a worksheet and would like to create a form and link the worksheet to
it.

Then, if I enter information into the worksheet it would also appear in the
form and vise versa.

Does anyone know how to do this and also create a data form please?


FSt1

Forms
 
hi
see this site......
http://www.contextures.com/xlUserForm01.html

as to the linking, use the Linked Cell Property of the text box control.

Regards
FSt1

"MarkOffice2007" wrote:

I have a worksheet and would like to create a form and link the worksheet to
it.

Then, if I enter information into the worksheet it would also appear in the
form and vise versa.

Does anyone know how to do this and also create a data form please?



All times are GMT +1. The time now is 11:43 PM.

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