Editing Worksheets inside an Addin?

[martjn]

Hey!

I Figured out the best way to have a table with some strings like..

1;Anders Svensson
2;Göran Hassel
3;Bo Lind
etc.

Inside an Addin. The addin itself will get values like 1;3;4.
And when they find the "1" it will go to the table inside the addin and getstring "Anders Svensson".
And when it searchs for 4 and doesnt find it. It will put an textbox to the user so he/she will be able to enter the 4th member.

Ok this should work with hardcoded table before it turned to .xla.

How can i add more values/ edit values inside the worksheet while its in the .xla format?

Do you understand what im trying to build?
An sort of "include-file" with editable positions and adding new one as the work goes on.


Any other suggestion would be cool to know about if you have some other idéas .

Best Regards
Martin.

 

[hatman]

To edit a sheet within an Addin file, enter the VBA Editor, then select the the ThisWorkbook Class Module in the Project Explorer Pane, and in the Properties Pane, change the value of the IsAddin property to False. At this point it will behave like a normal workook... when you are done editting the sheet content, then reste the IsAddin Property to true, and save the file....