+ Reply to Thread
Results 1 to 4 of 4

Keeping a combo box in a cell using vba code?

  1. #1
    Registered User
    Join Date
    10-20-2014
    Location
    Arkansas
    MS-Off Ver
    2010
    Posts
    41

    Keeping a combo box in a cell using vba code?

    I am wanting to use vba code to try to keep a combobox in a cell. and connect it to the height width and to move with the cell.

    Using the object positioning in format control does not work, when the combo box is hidden and the rows above it are hidden or unhidden.

    So I need the combo box to stay in that cell, I am having to use Active x combobox due to coding issues, and I can not use Data Validation (my boss does not like the look of Data Validation). I can not work vba code to save my life but this is kinda what I was thinking. Any help would be great!

    Please Login or Register  to view this content.
    Last edited by CtrlAltDelete; 10-31-2014 at 02:01 PM.

  2. #2
    Registered User
    Join Date
    10-20-2014
    Location
    Arkansas
    MS-Off Ver
    2010
    Posts
    41

    Re: Locking a cell in a combo box using vba code?

    Tried this, with no luck but it was from someone else post.
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Keeping a combo box in a cell using vba code?

    Hi,

    For Active X ComboBox 137 the following should work:
    Please Login or Register  to view this content.
    Lewis

  4. #4
    Registered User
    Join Date
    10-20-2014
    Location
    Arkansas
    MS-Off Ver
    2010
    Posts
    41

    Re: Keeping a combo box in a cell using vba code?

    it worked to a point I think it was just other vba codes i have conflicting it.

+ 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] Macro Code for cell locking
    By esmatullaharifi in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-17-2013, 09:50 AM
  2. Excel VBA Code for locking/unlocking a cell based on the value of another cell
    By latourjim in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-22-2013, 10:03 PM
  3. Custom Function locking up other code for cell coloring
    By juskojj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-25-2012, 04:21 PM
  4. VBA code for Locking Cell disabling Drop Downs Validation Lists
    By Leox5000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2012, 08:43 AM
  5. Problem with cell locking VBA code
    By drgogo in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-02-2010, 10:53 AM

Tags for this Thread

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