+ Reply to Thread
Results 1 to 9 of 9

Form Created - VBA Dropdown Doesnt Work When The Rows Are Hidden?

  1. #1
    Registered User
    Join Date
    09-23-2015
    Location
    UK
    MS-Off Ver
    2010
    Posts
    68

    Form Created - VBA Dropdown Doesnt Work When The Rows Are Hidden?

    Hi,

    I have created a "form" where you can put information into a number of fields, hit a "Submit" button and the information stacks up as a list below this form, I use the following code and works fine -

    Please Login or Register  to view this content.
    The list it stacks into I want to hide, however when I hide the rows where the list is, the 'stacking' doesnt seem to work anymore and only puts the information into row 37 each time and overwrites itself?

    Any ideas?

    Thanks
    Last edited by npsnps; 06-02-2016 at 09:38 AM.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Form Created - VBA Dropdown Doesnt Work When The Rows Are Hidden?

    Assuming that they're merged cells, try this:

    Please Login or Register  to view this content.
    Last edited by xladept; 06-02-2016 at 10:24 AM.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    09-23-2015
    Location
    UK
    MS-Off Ver
    2010
    Posts
    68

    Re: Form Created - VBA Dropdown Doesnt Work When The Rows Are Hidden?

    Thank you for the information but I cant seem to make this one work, it only moves the first box down (J9:O9) ?

  4. #4
    Registered User
    Join Date
    09-23-2015
    Location
    UK
    MS-Off Ver
    2010
    Posts
    68

    Re: Form Created - VBA Dropdown Doesnt Work When The Rows Are Hidden?

    Apologies, Ive managed to make it move all boxes but the same problem occurs, fine when unhidden, overwrites row when hidden?

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Form Created - VBA Dropdown Doesnt Work When The Rows Are Hidden?

    Try this:

    Please Login or Register  to view this content.
    Last edited by xladept; 06-07-2016 at 11:26 AM.

  6. #6
    Registered User
    Join Date
    09-23-2015
    Location
    UK
    MS-Off Ver
    2010
    Posts
    68

    Re: Form Created - VBA Dropdown Doesnt Work When The Rows Are Hidden?

    Comes up with the error - Run-time error 1004, cannot change part of a merged cell.

  7. #7
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Form Created - VBA Dropdown Doesnt Work When The Rows Are Hidden?

    Uno Mas:

    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    09-23-2015
    Location
    UK
    MS-Off Ver
    2010
    Posts
    68

    Re: Form Created - VBA Dropdown Doesnt Work When The Rows Are Hidden?

    Works beautifully, thank you for your help.

  9. #9
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Form Created - VBA Dropdown Doesnt Work When The Rows Are Hidden?

    You're welcome and thanks for the rep!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] HLOOKUP doesnt work in all rows
    By Immortal2014 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-20-2015, 04:58 PM
  2. [SOLVED] Freeze columns and rows doesnt seem to work
    By colwise in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-21-2015, 11:15 PM
  3. Click events on buttons created at runtime only work on the last button created
    By Treacle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2010, 05:44 AM
  4. Rows(i).Hidden = True doesn't work
    By Evil Red Smurf in forum Excel General
    Replies: 3
    Last Post: 06-22-2009, 06:26 AM
  5. In Word 2007, how do I work within a form created in Word 2003
    By LilyMarie in forum Word Formatting & General
    Replies: 1
    Last Post: 03-05-2009, 04:26 AM
  6. Doesn't work as it SHOULD .. Rows.Hidden /with SpecialCells
    By Gunnar Johansson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2006, 06:25 AM
  7. [SOLVED] =ROW-1, =SUBTOTAL(3,$B$2:$B2) don't work in hidden rows.
    By StargateFan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-25-2006, 03:10 PM

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