benjansen
06-25-2008, 03:33 AM
Hello all,
Hope you can help me....I want to do the following thing.
I have 1 userform with 10 textboxes each labeled txtBox"name".
I have 3 buttons, 1 x update fields and 1 x change fields and close form.
step 1
So when I open this excel sheet it opens the form when i fill in the textboxes and click on update. the first sheet called "details" is used to transport the values that were filled in towards the cells in collumn B.
I should close the form with "close form" and then save the spreadsheet.
step 2
When I open the same sheet afterwords i want to be able to change the values that were entered in step 1. and then click update or the change button.
I have tried some codes that I found online. but none were to my satisfaction......
You would be a great help if you could help me with this one.
Greetings,
Ben
PS: hope to hear from you soon.
Hope you can help me....I want to do the following thing.
I have 1 userform with 10 textboxes each labeled txtBox"name".
I have 3 buttons, 1 x update fields and 1 x change fields and close form.
step 1
So when I open this excel sheet it opens the form when i fill in the textboxes and click on update. the first sheet called "details" is used to transport the values that were filled in towards the cells in collumn B.
I should close the form with "close form" and then save the spreadsheet.
step 2
When I open the same sheet afterwords i want to be able to change the values that were entered in step 1. and then click update or the change button.
I have tried some codes that I found online. but none were to my satisfaction......
You would be a great help if you could help me with this one.
Greetings,
Ben
PS: hope to hear from you soon.