+ Reply to Thread
Results 1 to 8 of 8

cell C2 drop-down list option how to go to repeat go to blank go to 0 VBA code

  1. 11-12-2022, 07:49 AM #1
    rayhen
    rayhen is offline
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 365
    Posts
    175

    cell C2 drop-down list option how to go to repeat go to blank go to 0 VBA code

    source data in A2:A20

    Can someone please help me ? It would be much appreciated
    Attached Files Attached Files
    Last edited by rayhen; 11-13-2022 at 04:12 AM.
    Reply With QuoteRegister To Reply
  2. 11-12-2022, 08:00 AM #2
    torachan
    torachan is offline
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,411

    Re: cell C2 drop-down list option how to go to repeat go to blank go to 0 VBA code

    what is the problem ????
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
    Reply With QuoteRegister To Reply
  3. 11-12-2022, 08:04 AM #3
    rayhen
    rayhen is offline
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 365
    Posts
    175

    Re: cell C2 drop-down list option how to go to repeat go to blank go to 0 VBA code

    Sir How to make Cell C2 drop down menu list

    No repeat , No blank and No zero VBA code

    Final answer like Cell C2
    Last edited by rayhen; 11-12-2022 at 08:06 AM.
    Reply With QuoteRegister To Reply
  4. 11-12-2022, 09:52 AM #4
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: cell C2 drop-down list option how to go to repeat go to blank go to 0 VBA code

    VBA code not required.
    Helper column B (choose any free column) is used.
    In B2 then copy down
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Formula for DV in D2
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
  5. 11-12-2022, 10:01 AM #5
    rayhen
    rayhen is offline
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 365
    Posts
    175

    Re: cell C2 drop-down list option how to go to repeat go to blank go to 0 VBA code

    kvsrinivasamurthy Your method is correct, that is to increase the HELPER COLUMN, can it be obtained directly with VBA code? Thank you
    Reply With QuoteRegister To Reply
  6. 11-12-2022, 09:00 PM #6
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2503 and WPS V2024(12.1.0.18543)
    Posts
    3,920

    Re: cell C2 drop-down list option how to go to repeat go to blank go to 0 VBA code

    Put this code in your active sheet

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 11-13-2022, 04:11 AM #7
    rayhen
    rayhen is offline
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 365
    Posts
    175

    Re: cell C2 drop-down list option how to go to repeat go to blank go to 0 VBA code

    Quote Originally Posted by wk9128 View Post
    Put this code in your active sheet

    Please Login or Register  to view this content.
    Although not the result I wanted kvsrinivasamurthy but still thank you for your kind help

    @wk9128 you are so good you are so perfect
    Last edited by rayhen; 11-13-2022 at 06:50 AM.
    Reply With QuoteRegister To Reply
  8. 11-13-2022, 04:14 AM #8
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2503 and WPS V2024(12.1.0.18543)
    Posts
    3,920

    Re: cell C2 drop-down list option how to go to repeat go to blank go to 0 VBA code

    @rayhen You're Welcome. Glad to help . Thank You for the feedback and rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to exclude blank cell from drop down list.
    By Ariful Islam in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-22-2022, 03:16 AM
  2. VBA: Drop down list by clicking in any area of the blank cell
    By josekr80 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-11-2019, 04:42 AM
  3. Drop down list by clicking in any area of the blank cell
    By josekr80 in forum Excel General
    Replies: 2
    Last Post: 08-11-2019, 01:11 AM
  4. Please help need a cell to remain blank until after pwd is entered in drop down (vba code)
    By abenny11 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-10-2015, 07:13 PM
  5. [SOLVED] Cell with Data Validation(list Option) is accepting any value if the dependent is blank
    By hemesh in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-18-2013, 10:29 AM
  6. Refrence next blank cell to repeat VBA Code
    By SirAustin1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-11-2011, 02:22 AM
  7. Help: allow a blank as an option in a drop down list
    By lmm07468 in forum Excel General
    Replies: 6
    Last Post: 06-26-2008, 09:55 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1