View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pierre[_18_] Pierre[_18_] is offline
external usenet poster
 
Posts: 19
Default if then else problem

Hi,

can anybody tell me what is wrong in this snippet of code ?

If search_acc.Value < " " Then
result = search_acc.Value
Column = 23
ElseIf search_status < " " Then
result = search_status.Value
Column = 176
Else: GoTo nochoice
End If
.....
various code
.....
nochoice:
msgbox "you did not make a choice, make a choice !"


Where search_acc and search_status are comboboxes
Whatever you do, you allways end up with the messagebox from nochoice:
Please help !
Thanks,
Pierre