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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.