Copy dropdown selection into worksheet

dmqueen

Board Regular
Joined
Aug 5, 2014
Messages
53
Pleas 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 simple as possible please!
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
The dropdown is on the sheet, but I need to copy the value onto the sheet from within a macro.
 
Upvote 0
so your syntax is just:

Code:
Sheet.Range(Cell1,Cell2).Value = Sheet.Cells(Row, Column)

where the row and the column point to your drop down value.
 
Upvote 0
For example, on the 1st sheet it's dropdown15 I thought could apply it to my variable through myVariable = dropdown15.value or myVariable = dropdown1.boundItem but I can't get at the value I can copy it into the sheet where I want it if I could get at it.
 
Upvote 0
Dear Neon,

tried your suggestion:

<code>


Sub fContinueEntry()
'Get Machine value

RowNum = ActiveCell.Row
<highlight>
Sheet.Range(RowNum, 3).Value = Sheet.Cells(B, 1)</highlight>
Dim MachineIndex As Integer
MachineIndex = ActiveCell(RowNum - 4, "B").Value
Dim Machine As String
Machine = DropDown5.TargetValue
ActiveCell(RowNum, 2).Value = Machine
Sheet.Range(RowNum, 2).Value = Sheet.Cells(B, 1).Value
Dim Tube As Double
Tube = InputBox("Enter Tube")
ActiveCell(NewRowNum - 10, 2).Value = Tube

Dim CLR As Double
CLR = InputBox("Enter C.L.R.")
ActiveCell(NewRowNum - 10, 3).Value = CLR

Dim Grip As Double
Grip = InputBox("Enter Grip Length")
ActiveCell(NewRowNum - 10, 4).Value = Grip

End Sub
/<code>
And while it compiles ok, I get a Runtime Error 424 Object Required when try to run it. Am I doing something wrong?</code></code>
 
Last edited:
Upvote 0
The Controls call it Drop Down 5. It's a lengthy Listbox that populates from a named range on a separate sheet that I want the user to be allowed to enter a new choice that will also add to the named range and present as a choice net time, but for right now I'd be happy if I could just pull the selected value from the starting list.
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,218
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top