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
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
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks