using Forms and VBA within Excel
 

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

using Forms and VBA within Excel
 

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

using Forms and VBA within Excel
 

thank you very much (from a Private Pilot)
--
Roland Hoelscher
Project Manager


"JLGWhiz" wrote:

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


.

using Forms and VBA within Excel
 

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!

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Roland Hoelscher" wrote:

thank you very much (from a Private Pilot)
--
Roland Hoelscher
Project Manager


"JLGWhiz" wrote:

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


.