match case

I have made a user form to update worksheet "sheet1" there is a one combo box I have created with buy and sale 2 components in it. when I select "buy" option its going well and all data being copy to excel sheet but when I choose "sale "option, I want a reference or unique component from previous entry from "Buy" which relates to "sale" entry and update next to same "buy" option i.e same row.But I am not able to get a perfect code for this as when i click on "Sale" data being copy but one by one row which is not correct. I have done something below, any solution?

Please Login or Register  to view this content.

Moderators note: code tags added for you - this time

Check to see if 'Sale' or 'sale' is the option from your ComboBox.
The must be an exact match or else you will get no result to what you coded as a variable.

Use something like:

Please Login or Register  to view this content.

Atul, hi and welcome to the forum

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Thanks for quick reply, When I select Sale from Combo box its give me correct result if u see the code above, but my concern is I have already some data in rows with "buy" options in earlier dates for example for June 1 June 2 , June 3 and so on with range "A to N" respectively and "P" to "ab" for sale range.That means if I select "Buy" from combo box it goes to (A to N) row and if I select "Sale" option from combo box it goes to (P to AB)row, but on June 4 I have sold some stocks which was purchased on 2 nd June, but when I Select Sale from combo box it goes to first row not goes to the 2nd June row. I want to match and enter correct data into appropriate/relevant /correct row when I make a Sale entry. for ex, for 1 to 5 June I made "Buy" entries range "A to N" row series, now on June 6 I sold stocks which was purchased on 3 rd June, but when I click on "Sale" from combo box it goes to first row that is "P4 to AB4." I want data goes to appropriate row only when I select Sale order from combo box. I think for this there must be 1 or 2 unique components need as reference so the code makes perfect. I do not know how to do it either v look up or any match case code added to the existing code

atul, you only need to use [code etc foir the VBA, not for regular comments