Editing Worksheets inside an Addin?

martjn

New Member
Joined
Sep 27, 2006
Messages
6
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.
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

hatman

Well-known Member
Joined
Apr 8, 2005
Messages
2,664
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....
 

Watch MrExcel Video

Forum statistics

Threads
1,113,811
Messages
5,544,444
Members
410,610
Latest member
renatha prado
Top