using Forms and VBA within Excel
in [Programming]
|
Prev: SOS-Need to calculate number of working hours per each week of
Next: Filling in columns counting by Hex
From: Roland Hoelscher on 31 Mar 2010 14:49 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
From: JLGWhiz on 31 Mar 2010 15:08 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" <RolandHoelscher(a)discussions.microsoft.com> wrote in message news:0B2CA7CC-45B0-448A-BA36-D71A7A8525F6(a)microsoft.com... >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
From: Roland Hoelscher on 31 Mar 2010 15:58 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" <RolandHoelscher(a)discussions.microsoft.com> wrote in > message news:0B2CA7CC-45B0-448A-BA36-D71A7A8525F6(a)microsoft.com... > >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 > > > . >
From: ryguy7272 on 31 Mar 2010 16:29
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" <RolandHoelscher(a)discussions.microsoft.com> wrote in > > message news:0B2CA7CC-45B0-448A-BA36-D71A7A8525F6(a)microsoft.com... > > >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 > > > > > > . > > |