Creating IF statement for iRow Entry

Hello,

What Im trying to do is probably fairly simple, but I haven't been able to get it. What I basically am trying to do is, if a user selects "Apples" from combo-box3, I want the value from textbox 1 inserted on iRow, 3....If the word Oranges is selected from the combo-box 3 then I want the value in textbox 1 to be inserted on iRow, 4

So here's my code so far, but its not working:

Please Login or Register  to view this content.

any ideas why that isn't working?

Thanks for the help

Insert a Debug.Print Me.ComboBox3.Value in there to double-check the value of the ComboBox

Hey there

I tried that, still doesnt work.

Originally Posted by Whizbang

Insert a Debug.Print Me.ComboBox3.Value in there to double-check the value of the ComboBox

What errors are you getting? What is it doing or not doing?

The only issue I got was that it was putting the row number in column A, but the values in the next row down.

This worked fine for me:

Please Login or Register  to view this content.

Is there a "Records" worksheet in the workbook? Double check the spelling and ensure there is no trailing Space character in the WS name.

Basically, if 'Apples' is selected then the value of textbox1 should go into cell B3, if oranges is selected the value of textbox1 would go into cell B4

You know what Whizbang, that was the problem, the sheet name had a spelling error!

tHANKS for the second set of eyes and the suggestion!!

Originally Posted by Whizbang

Is there a "Records" worksheet in the workbook? Double check the spelling and ensure there is no trailing Space character in the WS name.

Glad you got it to work.