+ Reply to Thread
Results 1 to 3 of 3

ComboBox Linked Cell

  1. #1
    Valued Forum Contributor fredlo2010's Avatar
    Join Date
    07-04-2012
    Location
    Miami, United States
    MS-Off Ver
    Excel 365
    Posts
    762

    ComboBox Linked Cell

    Hello,

    I have a worksheet with few combo-boxes and they all have a linked cell. Now I was wondering if this will make the code run slower or not. Why is the purpose if the linked cell anyway? other than using it in formulas perhaps?

    Thanks

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: ComboBox Linked Cell

    Updating a displayed cell in code does have a cost, but only one combobox will be updated at a time and the update is done by a user, so the cost of updating a single cell is negligible. (When code updates a lot of cells all at once, there is a steep cost, which can be mitigated by turning off Application.ScreenUpdating.)

    The benefit is, as you suggest, being able to use it in cell formulas. If you're not doing that, then no harm in removing the link.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Valued Forum Contributor fredlo2010's Avatar
    Join Date
    07-04-2012
    Location
    Miami, United States
    MS-Off Ver
    Excel 365
    Posts
    762

    Re: ComboBox Linked Cell

    Thanks for the reply 6String. I will remove it because I am not really using it at all. Whenever I need to get the value of the object I will reference it directly.

+ 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. Combobox linked cell format problem
    By Schwizer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-30-2017, 04:18 PM
  2. ComboBox linked to different cell
    By NJH88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-13-2014, 09:22 AM
  3. ComboBox linked cell problem
    By minvai in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2014, 09:20 AM
  4. ComboBox on worksheet linked to a cell
    By dinamis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2014, 05:26 PM
  5. How to get Workbook_SheetChange code to run from a ComboBox dropdown linked cell
    By Warfarin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2013, 08:08 PM
  6. [SOLVED] Combobox linked cell and pivot table filter
    By Blake 7 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-05-2012, 09:58 AM
  7. [SOLVED] ComboBox Activex Linked Cell displaying numbers
    By Bishonen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2012, 12:31 PM

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