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.
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

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....
 

Forum statistics

Threads
1,141,011
Messages
5,703,725
Members
421,311
Latest member
tanujath

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top