Hello,
I am having the following problem:
I have a sheet with several textboxes and comboboxes (they are not part of a form, they were added to the sheet directly).
The texboxes/comboboxes have linkedcells. The textboxes/comboboxes get updated fine when I manually change the linkedcells content, however they are not when the cells get updated from my vba code (I have a loop changing the linkedcells and Id like to see the changes reflected in the spreadsheet as they happen).
Do you know how I could get the textboxes/comboboxes to get refreshed from my vba code?
Thank you!
Try hardcoding the textboxes/comboboxes inside your loop, then you wouldn't have to worry about linked cells.
My controls from the Forms menu adjust properly when their linked cells are changed with VBA.
Perhaps switching from ActiveX to Forms controls would work.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks