Macro for selecting cetain cell and entering data into another

**jlozolla** · 04-10-2009, 09:17 AM

I need help creating a macro to select data from one column of cells and be able to edit the data on the next column.

I have created a text box to open automatically when the file is opened. I want to be able to use the drop down box for channel to select the channel i want, then from there enter data for the serial and it pop up in the corresponding place.

I will post what i have so far. Thanks for any help you can provide.

**Paul** · 04-10-2009, 01:40 PM

Hi Jlozolla,

What you've posted and what you're asking to do don't match. Are you trying to add the Channel numbers from Sheet1 into the drop-down list, or - as your current code attempts - are you trying to load the sheet names into the drop-down list?

To load the sheet names, change:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Your code for CommandButton1 should then work to put whatever you enter into the Serial box onto that specific sheet in the next available row (and into column B).

If you're trying to load the Channel numbers into your drop-down list, change:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

**jlozolla** · 04-10-2009, 02:00 PM

Thanks for the help. Yes, i am trying to load the channel numbers into the drop-down list. I used the code you have and i had some compiling issues do to the faulty coding i have been using. I'm afraid the coding i have is all wrong. I went ahead and deleted the sheet loading code that i had and now the "Enter Data" button will not do anything when i click it on the form box.

I'm gonna attach the changes i made. Further assistance is greatly appreciated!!

**jlozolla** · 04-13-2009, 02:27 PM

I have the drop down numbers working now. Now I need to be able to manipulate the data in the serial number cell now. When i hit the "enter data" button nothing happens. I need help with the coding for that button.

Thanks.

**jlozolla** · 04-15-2009, 08:29 AM

pjoaquin,

I was trying to load the numbers and made the changes and the drop-down box seems to be working correctly. Now i need the serial number data to be entered when I hit the enter data box. Can you help with this?