How can I import a dropbox to another sheet using macro?

[RinorM]

in Sheet "Slutgiltigadimensioner" cell B3 I have a drop-down list. This i Want to import to Sheet "Indata" cell Q7. How do I write the code?

I have currently written this code but it only gives the value of which you choose in the drop-down list:

Please Login or Register  to view this content.

[Mumps1]

try:

Please Login or Register  to view this content.

[TMS]

See the attached example using Mumps1's code.


Regards, TMS

[RinorM]

I modified the code you gave me just a bit into this:

Please Login or Register  to view this content.

But it only gave me a value of "TRUE" in cell Q7

[TMS]

That's because your code doesn't do the same as Mumps1's code does. He uses the Copy Method with a destination range.

Your code is effectively comparing two things ... and coming up with TRUE.

[RinorM]

Oh Okay. TMS your code gives the arrow pointing down when pressing on cell Q7 But it only appears "1 dropped down cell". Not the whole list appears. I tried your example and that is exactly how I want it but it doesnt work like that when I paste it inside my module 1 code. How come?

I pasted this:

Please Login or Register  to view this content.

Where CalcDims() is my macro that i run

[TMS]

I have no idea. I just made up a small sample to test the code that Mumps1 provided. You probably need to upload your own example so we're all working off the same data.

Regards, TMS

[RinorM]

Excelforum2.xlsm123hjälp.jpg

The picture above shows how it appears. I have uploaded my example

[Mumps1]

The screenshot is not very helpful. Can you post a copy of your file?

[RinorM]

Hi Mumps. The copy of the file is in the same thread as the screenshot (Excelforum2.xslm) Thank you.

[Mumps1]

Try the attached file. First of all cells Q7 and R7 were merged so I had to unmerge them. You should avoid merging cells in Excel if at all possible because they most often cause problems when using VBA. Then I highlighted the drop down source range and gave it a name (ValList). I used the range name as the source in the Data Validation. The macro is in Module 2.

[RinorM]

That worked very well. Thank you very much for your help!

[Mumps1]

My pleasure.