-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
if nothing
-
A
Check if combobox has assigned value
Hello, I am using the value selected in a combobox as a sort of filter, as in If Range("A1")=ActiveSheet.OLEObjects("ComboBox1").Object.Value Then Range("B1") = Range("A1").value/ ActiveSheet.OLEObjects("ComboBox1").Object.Value However if ActiveSheet.OLEObjects("ComboBox1").Object.Value is...- always_confused
- Thread
- combobox if nothing isnothing null
- Replies: 2
- Forum: Excel Questions
-
M
Call Sub, if there is a Value in a cell
Hi everyone, I want to call a Sub, if there is change in a certain cell. With the following code, this works as lang as there is something in the cell. [CODE] Private Sub Worksheet_Change(ByVal Target As Range) If Target = Range("A1") Or Target = Range("A2") Then Call "Name of Sub" End...- M_Gross
- Thread
- call call a sub cell if nothing target
- Replies: 8
- Forum: Excel Questions
-
B
input box if cancel.. exit sub
I have this code below, it works well with the exception if "cancel" is clicked on the input box. It is selecting all of the shapes on the page and changes the color of them from yellow to brown. So basically it is running the rest of the code after cancel is clicked. Thanks What I would...- buzz71023
- Thread
- cancel exit sub if nothing inputbox cancel
- Replies: 2
- Forum: Excel Questions
