Copy DropDown Selection into Worksheet

[dmqueen]

Please help!

I have a dropdown list in Column B. I need to be able to copy the selected value into the worksheet by tomorrow or I'm fired! As easy as possible please.

[stnkynts]

Where in column B? B1, B2, every single cell in column B?

Where in the worksheet do you need to copy it to?

Do you want this to happen automatically when you select a value, click a button, or manually trigger a subroutine?

As clearly as possible please.

[dmqueen]

Sorry. It's @ the top of Col. B and the selection will copy into Column B to the new row created for data entry. I am successfully generating a part number in Column A and using Inputboxes to get the remaining info., but the Machine info. is large and ever changing. The dropdown is populated from a separate sheet. It will trigger from a macro attached to the dropdown box onMachineChange().

[stnkynts]

This doesn't make sense:

It's @ the top of Col. B and the selection will copy into Column B to the new row created for data entry.

Initially I thought we were talking about data validation but now I don't know. Is this a combobox? If so what kind of combobox is it (activex or form control). And what is "to the new row created for data entry"

I have no idea what this means:

It will trigger from a macro attached to the dropdown box onMachineChange().

At this point the only way I think we can help you is if you submit an example workbook which clearly shows a before and after example of what you want accomplished.

[dmqueen]

The entire program initially inserts a new row for data entry. That works great. Then it generates a new part number in column A, this too works great. The first two things happen after the user clicks a button for new Entry Input. The 1st subroutine ends there. Then the user needs to select a Machine from the drop down in Column B, which the macro needs to copy to the sheet. This does not work. This is supposed to happen when the user selects their machine. The list has the continueInput subroutine set to Activate when they click in the list. After the machine value is selected and copied to the list, guided user input continues until all columns are filled.

[dmqueen]

I'd be happy to attach if you tell me how. But it's a 33 MB file.

[stnkynts]

You attach it by clicking the "Go Advanced" button in the bottom right corner. From there you should be able to locate a "Manage Attachements" (if I recall correctly). You don't have to submit your complete workbook (33 MB is beyond the upload limit), just a valid representation of what you are trying to accomplish while mainting all applicable rows and columns. Most of the time macro's are precise and will only work on specified ranges and the closer your example workbook to the real one the better.

[dmqueen]

I uploaded an excerpt of the file. The first worksheet, the Machine worksheet it populates the drop down from, and the macro code. Thanks for your help in looking at it! It's very possible I'm not using it correctly. In fact, when I went into Excel, I tried placing another one and the tool tip under the Developer Insert tab said it was a Combo Box! The tt subroutine someone gave me on this board lists all my controls on a sheet called it Drop down 5. I just wanted a limited list at the top of the column they could pick from so they wouldn't have to type it in every time! The engineers loved my idea of using them, and now I can't get the value out of them. Boy do I have egg on my face! I'm trying to get back into coding after a 7 year medical recovery from a stroke, maybe I'm not ready. :/

[dmqueen]

In addition, the control I'm having trouble getting the selected value from is a Form Control Combo Box with the Settings as a list ti behave like a drop down list box. I hope this clears any confusion. Clears a lot for me, except how to get the value out of it!

[stnkynts]

The file you uploaded is no good. Sorry friend but I'm done for the day. Hope you still have your job tomorrow.