I want to change a label in another form based on the user input from the
main form. Here is what I have tried but failed:
On the main form, the user choose "Good morning", "Good afternoon" or "Good
evening". The content is linked to a cell (say "A1") on Sheet1. Then the main
form is closed and another form, say UserForm1 is called. I want one label on
UserForm1 to show "Good morning", "Good afternoon" or "Good evening" based on
the input of the main form. On the main form I tried
UserForm1.show
UserForm1.Label1.Caption= Sheets("Sheet1").Range("A1").Value
The form UserForm1 pop up, but nothing happens to the label.

I'll appreciate your help.

Can you put

Me.Label1.Caption = Sheets("Sheet1").Range("A1").Value

In the initialize event for UserForm1?


"Scott" wrote:

I want to change a label in another form based on the user input from the
main form. Here is what I have tried but failed:
On the main form, the user choose "Good morning", "Good afternoon" or "Good
evening". The content is linked to a cell (say "A1") on Sheet1. Then the main
form is closed and another form, say UserForm1 is called. I want one label on
UserForm1 to show "Good morning", "Good afternoon" or "Good evening" based on
the input of the main form. On the main form I tried
UserForm1.show
UserForm1.Label1.Caption= Sheets("Sheet1").Range("A1").Value
The form UserForm1 pop up, but nothing happens to the label.

I'll appreciate your help.

Sam, thanks a lot for you answer. I am not a programmer. I'm confused on
"the initialize event for UserForm1"

What's "the initialize event"? I just use "UserForm1.show" and the form
comes up. You mean I need "the initialize event"? And how to do that?

Many thanks.


"Sam Wilson" wrote:

Can you put

Me.Label1.Caption = Sheets("Sheet1").Range("A1").Value

In the initialize event for UserForm1?


"Scott" wrote:

I want to change a label in another form based on the user input from the
main form. Here is what I have tried but failed:
On the main form, the user choose "Good morning", "Good afternoon" or "Good
evening". The content is linked to a cell (say "A1") on Sheet1. Then the main
form is closed and another form, say UserForm1 is called. I want one label on
UserForm1 to show "Good morning", "Good afternoon" or "Good evening" based on
the input of the main form. On the main form I tried
UserForm1.show
UserForm1.Label1.Caption= Sheets("Sheet1").Range("A1").Value
The form UserForm1 pop up, but nothing happens to the label.

I'll appreciate your help.

From VBE window; from the left treevew right click the UserForm icon and View
Code. From the code panel 1st drop down select User form and form the second
drop down select Initialize event..1st drop down shows the controls and 2nd
one its events..

If this post helps click Yes
---------------
Jacob Skaria


"Scott" wrote:

Sam, thanks a lot for you answer. I am not a programmer. I'm confused on
"the initialize event for UserForm1"

What's "the initialize event"? I just use "UserForm1.show" and the form
comes up. You mean I need "the initialize event"? And how to do that?

Many thanks.


"Sam Wilson" wrote:

Can you put

Me.Label1.Caption = Sheets("Sheet1").Range("A1").Value

In the initialize event for UserForm1?


"Scott" wrote:

I want to change a label in another form based on the user input from the
main form. Here is what I have tried but failed:
On the main form, the user choose "Good morning", "Good afternoon" or "Good
evening". The content is linked to a cell (say "A1") on Sheet1. Then the main
form is closed and another form, say UserForm1 is called. I want one label on
UserForm1 to show "Good morning", "Good afternoon" or "Good evening" based on
the input of the main form. On the main form I tried
UserForm1.show
UserForm1.Label1.Caption= Sheets("Sheet1").Range("A1").Value
The form UserForm1 pop up, but nothing happens to the label.

I'll appreciate your help.

Sam and Jacob, thank you both a lot. Problem is solved.

"Jacob Skaria" wrote:

From VBE window; from the left treevew right click the UserForm icon and View
Code. From the code panel 1st drop down select User form and form the second
drop down select Initialize event..1st drop down shows the controls and 2nd
one its events..

If this post helps click Yes
---------------
Jacob Skaria


"Scott" wrote:

Sam, thanks a lot for you answer. I am not a programmer. I'm confused on
"the initialize event for UserForm1"

What's "the initialize event"? I just use "UserForm1.show" and the form
comes up. You mean I need "the initialize event"? And how to do that?

Many thanks.


"Sam Wilson" wrote:

Can you put

Me.Label1.Caption = Sheets("Sheet1").Range("A1").Value

In the initialize event for UserForm1?


"Scott" wrote:

I want to change a label in another form based on the user input from the
main form. Here is what I have tried but failed:
On the main form, the user choose "Good morning", "Good afternoon" or "Good
evening". The content is linked to a cell (say "A1") on Sheet1. Then the main
form is closed and another form, say UserForm1 is called. I want one label on
UserForm1 to show "Good morning", "Good afternoon" or "Good evening" based on
the input of the main form. On the main form I tried
UserForm1.show
UserForm1.Label1.Caption= Sheets("Sheet1").Range("A1").Value
The form UserForm1 pop up, but nothing happens to the label.

I'll appreciate your help.