Using macro without permission?

[sam26479]

Hey everyone, I am a new user on Excel and I have been using tutorial succesfully so far, however im stuck with a problem.

I needed drop box for a project so I used activex dropbox and needed the value of the drop box in a cell so i used range ("A1") = me.combobox1.value.
Everything worked so far. but then I tried saving and it didn't work because i'm on my work computer and I don't have access to macro. The box can't be enabled.

Called the IT guy and he can't give me the permission tu use them because it could ''harm'' the computer.

Are there any way i can either, get the value of the combobox without using macros or save my file without macros enables or get my IT guy to save it with his permission and send it back? And how?

Thank you very much

 

[Jonmo1]

Welcome to the board.

In design mode,
Right click on the combobox and choose properties
find the property called "Linked Cell"
Type in the cell reference you want to put the value in like A1
Include the sheetname if necessary Sheet2!A1

 

[sam26479]

Welcome to the board.

In design mode,
Right click on the combobox and choose properties
find the property called "Linked Cell"
Type in the cell reference you want to put the value in like A1
Include the sheetname if necessary Sheet2!A1

Thanks a lot, almost seemed too easy! This info will help me a lot !

 

[Jonmo1]

Glad to help, thanks for the feedback.