Excel Form to enter Data Help

[Nitefoxxx]

Hi all...

I have started a mini project - I would like to be able to open a Form I have created of which it will have a 17 text boxes that will allow
my to enter data. When entered it will put that information into 17 cells on another sheet - this will be updated each hour so it will be required that the information is "updating" and also keeping the information in the form eac hour it is open.

Is this possible? im struggling as non of the guides on google seem to cover this.

Any help would be mucho appreciated!

I've attached a sample of what im kinda after if that helps.

[davesexcel]

You can send the text box values into a hidden sheet, then when you close the userform the values will be stored, show the userform again and the stored values will populate the textboxes.

You can access the hidden sheet, by right clicking on any sheet tab and select unhide sheet.
Add to the code to add more actions

Please Login or Register  to view this content.