Hi, I have the following code which zeros quantities and weight when a statement is selected but it doesn't seem to work and I can't see why?
Private Sub ComboBox37_Change() 'THIS IS TO REMOVE THE WHEEL FITTINGS FROM THE PRODUCT STRUCTURE Dim s$ s = ComboBox37.Text If s = "N/A" Or s = "SUPPLY LOOSE-NOTE39" Or s = "NOTE72-NO FITTINGS REQ'D" Then Me.TextBox27.Value = 0 Me.TextBox55.Value = 0 End If End Sub
Dim s as String
Should I put that at begining?
replaceDim s$
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Hi,
There is nothing incorrect in your code. If it is not doing what you expect, the combobox text is not what you think it is- remember it must match exactly and is case sensitive.
There is no difference between
andDim s$
Dim s As String
Don
Please remember to mark your thread 'Solved' when appropriate.
Your right xlnitwit, had bloody brackets, Thanks everyone for your help :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
bralew 
Register To Reply
Bookmarks