Hello,
I have ActiveX Combobox. When I clear Combobox, the linked cell seems to have a value. See attached worksheet. Cell A1 is a linked cell and Cell A5 has formula Isblank(A1). Cell A5 says FALSE when there is not value in Combobox selected.
Any help will be greatly appreciated
SJM
Hi,
I can only assume that Excel treats the fact that A1 is marked as linked to something (the combobox as it happens) means that it regards it as not empty.
In fact it's not just a combobox. If you put =IF(1=1,"",99) in a cell and test that with an ISBLANK() it will also show False.
Try instead
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you Richard for workaround. Will keep in mind from now on to avoid error.
SJM
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks