Paste value from combobox into cell

[enfantter]

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]

[VBA] Range("A1").Value = cboResponsible1.Value[/VBA]

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

[enfantter]

hmmm
This is exactly what i tried

[VBA]Sub registrer()

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


End Sub[/VBA]

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

[lucas]

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]

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]

its the sub called "registrer" in the module1

[enfantter]

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.
[VBA]

Sub registrer()

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


End Sub

[/VBA]

i have also tried the following...
[VBA]

Sub registrer()

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


End Sub

[/VBA]

this doesnt work either ...

[enfantter]

Is it a problem that the combobox is in the excel sheet

[tpoynton]

[vba]Sheets("base").Range("a1").Value = Sheets("Startside").Comraadgiver.Value[/vba]