Where are the userforms? 
Author Message
 Where are the userforms?

By trial and error and the great help of this newsgroup, for which I want to
thank tou all, I made a lot of macro's in Excel 6.0 using a separate sheet
for every diolog box (that was how to do it in Excel 6.0). Meanwhile I have
"translated" this file to VBA/Excel 2000 and even made it an Add-inn. It all
works fine, but if I would like to change a dialog sheet (which I think in
Excel/VBA you call user forms?) I do not know where I can find them! Could
anyone please enlighten me?
TIA
Theo


Thu, 08 Jul 2004 19:51:38 GMT  
 Where are the userforms?
Hi Theo,

Open your workbook and press Alt+F11. On VBE action Insert Menu > UserForm
command.

If Toolbox command bar is hidden, go View menu > Toolbox command.

HTH



Quote:
> By trial and error and the great help of this newsgroup, for which I want
to
> thank tou all, I made a lot of macro's in Excel 6.0 using a separate sheet
> for every diolog box (that was how to do it in Excel 6.0). Meanwhile I
have
> "translated" this file to VBA/Excel 2000 and even made it an Add-inn. It
all
> works fine, but if I would like to change a dialog sheet (which I think in
> Excel/VBA you call user forms?) I do not know where I can find them! Could
> anyone please enlighten me?
> TIA
> Theo



Thu, 08 Jul 2004 22:01:54 GMT  
 Where are the userforms?
Thanks for your reply Orlando, but that is not my problem. Sorry if I did
not explain it clear enough.
What I want to do is to open the existing dialog sheets I made with
VBA/Excel 6.0. In other words, in Excel 6.0 the dialog boxes were on a
(dialog)sheet and that I can not find. Although they apear on the screen
fine and the macro's run perfectly when I start them. What am I missing
here???

Kind Regards
Theo



Quote:
> Hi Theo,

> Open your workbook and press Alt+F11. On VBE action Insert Menu > UserForm
> command.

> If Toolbox command bar is hidden, go View menu > Toolbox command.

> HTH



> > By trial and error and the great help of this newsgroup, for which I
want
> to
> > thank tou all, I made a lot of macro's in Excel 6.0 using a separate
sheet
> > for every diolog box (that was how to do it in Excel 6.0). Meanwhile I
> have
> > "translated" this file to VBA/Excel 2000 and even made it an Add-inn. It
> all
> > works fine, but if I would like to change a dialog sheet (which I think
in
> > Excel/VBA you call user forms?) I do not know where I can find them!
Could
> > anyone please enlighten me?
> > TIA
> > Theo



Fri, 09 Jul 2004 02:46:36 GMT  
 Where are the userforms?
If it really is the old style dialog sheets, maybe they're hidden.

Try Format|Sheet|Unhide

Quote:

> Thanks for your reply Orlando, but that is not my problem. Sorry if I did
> not explain it clear enough.
> What I want to do is to open the existing dialog sheets I made with
> VBA/Excel 6.0. In other words, in Excel 6.0 the dialog boxes were on a
> (dialog)sheet and that I can not find. Although they apear on the screen
> fine and the macro's run perfectly when I start them. What am I missing
> here???

> Kind Regards
> Theo



> > Hi Theo,

> > Open your workbook and press Alt+F11. On VBE action Insert Menu > UserForm
> > command.

> > If Toolbox command bar is hidden, go View menu > Toolbox command.

> > HTH



> > > By trial and error and the great help of this newsgroup, for which I
> want
> > to
> > > thank tou all, I made a lot of macro's in Excel 6.0 using a separate
> sheet
> > > for every diolog box (that was how to do it in Excel 6.0). Meanwhile I
> > have
> > > "translated" this file to VBA/Excel 2000 and even made it an Add-inn. It
> > all
> > > works fine, but if I would like to change a dialog sheet (which I think
> in
> > > Excel/VBA you call user forms?) I do not know where I can find them!
> Could
> > > anyone please enlighten me?
> > > TIA
> > > Theo

--

Dave Peterson



Fri, 09 Jul 2004 04:43:33 GMT  
 Where are the userforms?
Thanks for your reply Dave, but that was it not either. But your suggestion
got me thinking and I did find it.
You have to set in the properties of this workbook that it is not an AddIn
(Addin = False). Stupid me.
Anyway thanks for your support Dave and Orlando.

Kind regards,
Theo



Quote:
> If it really is the old style dialog sheets, maybe they're hidden.

> Try Format|Sheet|Unhide


> > Thanks for your reply Orlando, but that is not my problem. Sorry if I
did
> > not explain it clear enough.
> > What I want to do is to open the existing dialog sheets I made with
> > VBA/Excel 6.0. In other words, in Excel 6.0 the dialog boxes were on a
> > (dialog)sheet and that I can not find. Although they apear on the screen
> > fine and the macro's run perfectly when I start them. What am I missing
> > here???

> > Kind Regards
> > Theo



> > > Hi Theo,

> > > Open your workbook and press Alt+F11. On VBE action Insert Menu >
UserForm
> > > command.

> > > If Toolbox command bar is hidden, go View menu > Toolbox command.

> > > HTH



> > > > By trial and error and the great help of this newsgroup, for which I
> > want
> > > to
> > > > thank tou all, I made a lot of macro's in Excel 6.0 using a separate
> > sheet
> > > > for every diolog box (that was how to do it in Excel 6.0). Meanwhile
I
> > > have
> > > > "translated" this file to VBA/Excel 2000 and even made it an
Add-inn. It
> > > all
> > > > works fine, but if I would like to change a dialog sheet (which I
think
> > in
> > > > Excel/VBA you call user forms?) I do not know where I can find them!
> > Could
> > > > anyone please enlighten me?
> > > > TIA
> > > > Theo

> --

> Dave Peterson




Sat, 10 Jul 2004 07:36:54 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. Opening userforms from other userforms

2. I am trying to update a record, i am not using data control

3. I am attempting to change a default setting and am lost

4. UserForms - Am I going to get myself in trouble?

5. UserForms & User responses

6. passing values between userforms

7. E-mailing Excel files that contain UserForms

8. cancelling userforms

9. irratic behaviour with userforms

10. 2 UserForms, one always on top


 
Powered by phpBB® Forum Software © phpBB Group