using Forms and VBA within Excel

[Roland Hoelscher]

I need to develop an application with Excel which will include Forms and VBA
code.
I have done small projects like this before but this will be significantly
larger with 6-10 forms and navigation (via command buttons) between the forms.
I have heard rumors that forms within Excel can be troublesome (e.g. they
can disappear without warning). I have never had problems with this before.
But still wanted to ask the community - are there know issues with using
Forms and VBA within Excel. The main functionality of the app will be to
validate and capture data, store the data in Excel and then report on the
data.
Thank you,

 

[JLGWhiz]

If you follow the guidelines in the help files for creating UserForms and
adding controls to them, there should be no problem with the form
disappearing spontaneously. Most of the instances of such disappearances
are pilot error.

 

[Roland Hoelscher]

thank you very much (from a Private Pilot)

 

[ryguy7272]

Once I worked on a project where I had to create 50+ UserForms in the
workbook, and move around between the Forms based on user selection/input. I
never had a single problem with it.

Good luck!