Using Named Ranges or cellsreferences in .XLA

[MarMo]

Hi there ,
This is my first request through this forum, and i'll try to explain my problem.
I would like to use cell reference or Range Names within an Addin (.xla) file.
Attached you'll find a testfile.
(Example attached must be saved as an Addin.)

For example , i would like to get a numeric value from the user in a userform, the Addin needs to put that value in a cell or range name within the .xla file for futher use in the future.

Is it possible to use cell reference within an .XLA file??

Thanks for your help
Mario

[Richard Schollar]

Hi

Have you tried:

Please Login or Register  to view this content.

?

Richard

[MarMo]

Richard ,

I did not try it , because i think the ThisWorkbook.Sheets is referring to the open workbook or am i mistaken?
Or do i need to refer as : MyAddin.("Sheet1").Range("A1").Value = "Some value"

Mario

[romperstomper]

ThisWorkbook refers to the workbook containing the code.
Activeworkbook refers to the active workbook.

[MarMo]

Hi guys ,

The code with "Thisworkbook....." works fine, thanks for that.
How can i be sure the last updated values within XLA file are saved.
When i close Excel and reoopen it , the last values are not saved with the XLA file.
How can i do this?

Thanks
Mario

[romperstomper]

As with changes to any workbook, you need to ensure the workbook is saved after you make the changes (thisworkbook.save)

[MarMo]

As with changes to any workbook, you need to ensure the workbook is saved after you make the changes (thisworkbook.save)

Of course.
Me been stupid.

Thanks a lot.
For me this post has been solved.