VBA UseForm

Dear Experts,
I want to make a useform for data entry in my excell sheet. there are three button in my useform. No 1: its a combo box & i select data from here. No 2: Its a date picker & select date from here. No 3: Its comand button & caption save & update. Now if i fill all data in useform & if i click comand button then data will save & close the useform. combo box data will save a1 cell & date picker data will save c1 cell. but if a1 & c1 cell already have any data then my saved data will go next cell that means A2 & c2 Cell. what code i use for this. please help me.

Best regards
Wahid

Dear Expert,
I am not clear. please help me in details.

Dear Rachel,

I think I know exactly what you want.

At the start of the Command_Button, please add the following code:

Please Login or Register  to view this content.

The outlined numbers corresponds to the cells (1 = A; 2 = B and so on.)

The iRow line looks for the next empty cell and writes on that row.

Let me know if that worked.

Best regards,
Filipe

Cross Posted : https://www.mrexcel.com/forum/excel-...a-useform.html

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).