PDA

View Full Version : Paste value from combobox into cell



enfantter
12-28-2009, 08:54 AM
This might be incredibly simple, but i cannot figure it out right.

i have a combobox "comboXX" which has a value which i wanna print in a cell "A1".

is there a easy way to do this....


appreciate it!

lucas
12-28-2009, 10:21 AM
Range("A1").Value = cboResponsible1.Value

If it's an activeX combobox......you don't say.

enfantter
12-28-2009, 03:17 PM
hmmm
This is exactly what i tried

Sub registrer()

Sheets("Data").Range("a1").Value = Combobox.Value


End Sub

combobox is a dropdown list from where i choose a value - does anybody have a clue of what i'm doing wrong??

lucas
12-28-2009, 04:38 PM
is combobox the actual name of the combobox?

after seeing your post at 3 I'm not sure what we are working with here.

Is there just no possible way for you to post the example that is not working?

enfantter
12-29-2009, 03:09 AM
sure ill post it. In this book its called comraadgiver ... and i wanna paste the chosen value from that combobox to A1 in the sheet called "base"

enfantter
12-29-2009, 03:10 AM
its the sub called "registrer" in the module1

enfantter
12-29-2009, 05:37 AM
I have tried to run the code without the combobox ...
This works - so im guessing that the error must stem from the right hand side.


Sub registrer()

Sheets("Data").Range("a1").Value = Combobox.Value


End Sub


i have also tried the following...


Sub registrer()

Sheets("Data").Range("a1").Value = Combobox.text


End Sub


this doesnt work either ...

enfantter
12-29-2009, 06:19 AM
Is it a problem that the combobox is in the excel sheet

tpoynton
12-29-2009, 06:59 AM
Sheets("base").Range("a1").Value = Sheets("Startside").Comraadgiver.Value