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" wrote in
message ...
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,

--
Roland Hoelscher
Project Manager