Combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ive tried the below - howver doesnt seem to call CL, always calls "Value"

Thanks

Private Sub ComboBox1_Change()

If Worksheets("Sheet1").Range("AA3").Value = "C" Then
Call CL
Else
Call Value
End If
End Sub
 
Teresa,

Not sure of what you solution is but in you original post you have
apparently used the word "Value" as the name of a macro. This is NOT a good
idea, as Value is a reserved word with a specific meaning in vba
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
UserForm QueryClose 2
Append Worksheet name to each begining of each row with values 2
Text search only finds 1st result 6
Help? Anyone see problem with this macro? Way to condense it? 2
Hide Entire Rows Range 6
Simple Macro 1
copy only from a cell with data in it 1

Back
Top