+ Reply to Thread
Results 1 to 11 of 11

combo box code help

  1. 07-08-2013, 07:06 PM #1
    laduk
    laduk is offline
    Registered User
    Join Date
    10-28-2012
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    37

    combo box code help

    this is the code im trying to use

    if me.namebox.Value = sheet3.Cell.b1 then me.brix.Value = range.("brix")

    cheers
    Reply With QuoteRegister To Reply
  2. 07-08-2013, 07:53 PM #2
    tehneXus
    tehneXus is offline
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: combo box code help

    try
    Please Login or Register  to view this content.
    where "brix" is a named range?
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES
    Reply With QuoteRegister To Reply
  3. 07-08-2013, 08:06 PM #3
    laduk
    laduk is offline
    Registered User
    Join Date
    10-28-2012
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: combo box code help

    brix is a range on sheet 1, i dont get any errors now but it dont pick up the range either
    cheers
    Reply With QuoteRegister To Reply
  4. 07-09-2013, 08:05 AM #4
    laduk
    laduk is offline
    Registered User
    Join Date
    10-28-2012
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: combo box code help

    this is the sheet I am trying to use the code

    cheers
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 07-09-2013, 08:16 AM #5
    Solus Rankin
    Solus Rankin is offline
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: combo box code help

    The range brix seems to be all of column B. And me.brix is a combo box.

    Are you trying to add all items in column B to your combobox?
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."
    Reply With QuoteRegister To Reply
  6. 07-09-2013, 08:19 AM #6
    laduk
    laduk is offline
    Registered User
    Join Date
    10-28-2012
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: combo box code help

    yes as long as namebox = sheet3 cell b1 or column c if namebox = sheet3 cell b2

    thanks
    Last edited by laduk; 07-09-2013 at 08:23 AM.
    Reply With QuoteRegister To Reply
  7. 07-09-2013, 08:25 AM #7
    Solus Rankin
    Solus Rankin is offline
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: combo box code help

    Try: (untested)

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 07-09-2013, 08:33 AM #8
    laduk
    laduk is offline
    Registered User
    Join Date
    10-28-2012
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: combo box code help

    no sorry still not working

    thanks
    Reply With QuoteRegister To Reply
  9. 07-09-2013, 08:47 AM #9
    Debraj Roy
    Debraj Roy is offline
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: combo box code help

    Hi Laduk..

    namebox is a label.. and I dont hink.. there was any CHANGE event for label..

    and secondly.. BRIX range is Complete B:B.. try to avoid it..
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...
    Reply With QuoteRegister To Reply
  10. 07-09-2013, 08:55 AM #10
    laduk
    laduk is offline
    Registered User
    Join Date
    10-28-2012
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: combo box code help

    Great thanks so simple now a text box and works
    thanks all
    Reply With QuoteRegister To Reply
  11. 07-09-2013, 09:01 AM #11
    Debraj Roy
    Debraj Roy is offline
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: combo box code help

    happy to Help..
    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)

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