+ Reply to Thread
Results 1 to 2 of 2

Make a merged cell bank (independent) when drop down list changes to a specific value ?

  1. #1
    Registered User
    Join Date
    10-01-2016
    Location
    Australia
    MS-Off Ver
    2011
    Posts
    1

    Question Make a merged cell bank (independent) when drop down list changes to a specific value ?

    Hi all,
    I am a newbie of Excel and am struggling with drop down list. The problem is:
    - I have a drop down list on B3 which contains, let's say, PIG and CAT.
    - I have a independent merge cell from D5 to D10 , called "SKY"
    - When CAT value is selected, people can fill all informations in SKY cell.
    - Then I want to change to PIG, and I would like all the information which I have filled before becoming blank, so that I can fill new information in SKY cell for PIG.

    Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)

    Select Case Range("B3")
    Case "PIG"
    Range("SKY").value = ""


    End Sub
    I have tried it with the code below but it doesn't work. It clears the content but it is able to fill a new information.
    Anyone help me could be appreciated.
    Thanks a lot

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: Make a merged cell bank (independent) when drop down list changes to a specific value

    You probably need the Change event to clear the merged cell and the Selection Change event to store the information in the merged cell.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. two independent drop down list on one sheet, with various macro's attached
    By boss1944 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2015, 07:51 PM
  2. [SOLVED] How to make drop down list to change formulas in cell?
    By yes man in forum Excel General
    Replies: 15
    Last Post: 11-13-2013, 08:21 PM
  3. Replies: 2
    Last Post: 08-02-2013, 08:04 AM
  4. Replies: 0
    Last Post: 02-14-2013, 01:05 PM
  5. Populate Specific Cell Based on Values in Independent Cells
    By NahRoots in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-26-2011, 10:46 AM
  6. How to make a macro cell independent
    By Ads. in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-17-2011, 08:43 AM
  7. [SOLVED] How do I make a drop down list to pick from for a cell in Excel
    By bbiernbaum in forum Excel General
    Replies: 2
    Last Post: 06-15-2005, 10:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1