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
|