I need my userform to input data in the first empty cell of a row

**msmitherc** · 02-14-2014, 03:49 PM

Good afternoon,

I have created a userform to input data into a tracker i have created. Currently, it enters the data into the activecell and the two cells to the immediate right. I would like to modify my userform and code to input data into the first three empty cells of a row, with the row being dependent upon a dropdown box of names. The names are all in Column A. Below is my current code. Please help.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**alansidman** · 02-14-2014, 04:23 PM

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

Posting code between

Please Login or Register  to view this content.

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 in the forum rules

(Because you are new to the forum, I have added them for you today. Please read all Forum Rules and comply in the future.)

**msmitherc** · 02-14-2014, 04:26 PM

Thank you, I appreciate it.

**alansidman** · 02-14-2014, 04:37 PM

Try this, but without seeing your spreadsheet, this is a guess.

Please Login or Register  to view this content.

**msmitherc** · 02-14-2014, 04:47 PM

Thanks for the help. I tried the code you suggested and the data was entered on the first empty row of the worksheet (All the way at the bottom). What i am hoping to do is use my userform and add a combobox which contains employee names (these are located in A3:A27). When the employee name is selected, I would like the data from the userform to be entered into the first empty cell (and the two to the immediate right) of the corresponding row on the worksheet. I would upload an attachment of my worksheet but i am afraid that is forbidden by my employer.

**alansidman** · 02-14-2014, 07:09 PM

Better understanding. Thanks for the explanation.

Try this:

Please Login or Register  to view this content.

I need my userform to input data in the first empty cell of a row

LinkBack

Thread Tools

Rate This Thread

Display

I need my userform to input data in the first empty cell of a row

Re: I need my userform to input data in the first empty cell of a row

Re: I need my userform to input data in the first empty cell of a row

Re: I need my userform to input data in the first empty cell of a row

Re: I need my userform to input data in the first empty cell of a row

Re: I need my userform to input data in the first empty cell of a row

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Data from Userform not going into last empty cell

[SOLVED] userform data to cell in empty column

Dynamic updating of current userform values based on userform data input or commandbutton

Taking data from an Input box and putting it in the first empty cell in a range

Help - input data in next empty row

Bookmarks

Bookmarks

Posting Permissions