Change values of labels in a userform through another userform

Zhennie · 10-29-2009, 04:55 AM

Here is what I'm trying to do: Let's say I have a simple userform with labels as follows:

(Label1) John's birthday: (Label2) 12.10.1974
(Label3) Mary's birthday: (Label4) 15.03.1978

(Button1) Change Birthdays

Let's say want to change the birthdays I see, so I press the button and enter the new values through another userform with inputboxes.

How do I make that change permanent, so that next time I start the macro in the labels 2 and 4 I have the last entered values for the birthdays???

**royUK** · 10-29-2009, 05:13 AM

You can't unless the values are stored perhaps in a hidden sheet then used on initialising the form.

I can't see why you are taking this approach. Why two userforms?

Why not have a table of names birthdays & use the form to amend that, see thae databaseform here

http://excel-it.com/vba_examples.htm

Zhennie · 10-29-2009, 05:16 AM

That would be easier, I guess. But it means there is no way to actually change the macro itself through a userform??

**royUK** · 10-29-2009, 05:27 AM

You can change a macro through code, but it is not a simple process. The main point is that you cannot protect the VBA Project if you choose this method.

See Chip Pearson