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.
|
Similar Threads
