+ Reply to Thread
Results 1 to 3 of 3

should I use hide/unhide with userform?

  1. #1
    Forum Contributor
    Join Date
    01-05-2009
    Location
    South Dakota, USA
    MS-Off Ver
    365
    Posts
    152

    should I use hide/unhide with userform?

    Here is what I want to do,

    I have a report form for my volunteer fire department, and at this time it has five different sections three of which are only necessary on certain calls. There is a basic information section, a section to fill out if it was a structure fire, a section for vehicle #1 and another for vehicle #2. I will probably make it more in depth later, but for now, I would like to be able to hide/unhide the unneeded sections based on the first cells input which is the type of call being reported. Especially on the vehicle sections, I would like to have a userform to pop up if the user inputs that it was a motor vehical accident. That I know how to do but I don't know how to go from there. I had thought about hiding/unhiding rows based on the userforms' input. The user form would either with check boxes or with a text box know how many vehicles were involved and unhide the necessary sections ie. one car = one section, three cars = three sections each looking alike except having veh #1, 2, 3, before them. Am I thinking right or is there perhaps a better way to do what I am wanting to?
    I tried to make this clear, but if you don't understand, ask and I will try to clarify.

    Thanks

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: should I use hide/unhide with userform?

    Hello 2Funny4Words,

    You could create a named range for each section you want to show or hide. Using the Worksheet_Change event you can monitor which cell has been selected and show the correct UserForm. The controls on the form can then decide which named range needs to be hidden or shown.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    01-05-2009
    Location
    South Dakota, USA
    MS-Off Ver
    365
    Posts
    152

    Re: should I use hide/unhide with userform?

    Thanks Leith,

    I will post back later when I go to do this. I may need a little help but I think that I will be able to get started.

    Thanks again

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1