+ Reply to Thread
Results 1 to 5 of 5

How can I link a Macro userform to a specific cell?

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Surrey B.C.
    MS-Off Ver
    2013
    Posts
    155

    Thumbs up How can I link a Macro userform to a specific cell?

    So I Know how to Make A user Form (drop down)Combo Box. As well, I linked it To a Column of Company Names on worksheet Number 3.

    Now I would like to recall it to Worksheet number 1, in a specific cell ("B8").

    I would also, like to link a second (drop down)Combo box to another cell in sheet 1 ("B9"). Where as when I chose the customer from the list, It triggers an autofill in three other Cells ("B10,B14,B15). The source of their autofill would be from sheet 3.

    Reason I need two sources is that the companies i deal with often have more than one supervisor with different phone numbers etc.

    Is this even possible?
    Any Help or direction would be greatly appreciated.
    Thank you for your time.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: How can I link a Macro userform to a specific cell?

    Assuming a simple ComboBox called ComboBox1, you could right-click that field and select VIEW CODE, that should open a the ComboBox1_Change event where you can enter the instructions on what you want to happen:

    Please Login or Register  to view this content.
    Perhaps you can prefill B10, B14 and B15 with VLOOKUP formulas working off the value in B9.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Surrey B.C.
    MS-Off Ver
    2013
    Posts
    155

    Re: How can I link a Macro userform to a specific cell?

    Thanks Jerry Ill give it whirl

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: How can I link a Macro userform to a specific cell?

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  5. #5
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Surrey B.C.
    MS-Off Ver
    2013
    Posts
    155

    Re: How can I link a Macro userform to a specific cell?

    The link For Combo Box Works. Thank you for That.

+ 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. Label command in userform to link to cell
    By Cremorneguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-10-2016, 09:24 PM
  2. Userform to use inputted value to link a cell
    By JS-FZ1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-11-2010, 10:32 AM
  3. How do you link a spreadsheet cell eg B5 to a Userform Textbox?
    By Falcon703549 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 06-27-2010, 01:15 PM
  4. Macro to search Specific Records and Create Link
    By rdcnaz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2010, 10:12 PM
  5. Macro to Update a Specific Link
    By ln_excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2007, 07:08 PM
  6. [SOLVED] Link from a specific Cell in Excel to a specific para. in Word
    By CathyK in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-10-2006, 11:45 AM
  7. [SOLVED] How to Link value from a Cell to a control in the userform
    By Shuvro Basu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2005, 08:30 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