Running macro from another sheet - VSTO

[Przemek]

Hi,

I've got following situation. Got to 2 sheets, one as a kind of
dashboard (import previous budgets, create new one) and second with
the (supposed to be) imported budget. I've also written simple budget
class with few fields (I'm using VS2008, NET 3.5). I'm reading xml
file to create budget object and I do not know how to pass data from
budget object to cells in another sheet. Let me be more clear:
In Sheet called "Dashboard" user will choose which budget(s) to
import, budgets' objects are created and now I want to switch somehow
to Sheet "Budget" to fill proper cell with data. How can I do it?

Przemek

 

[ryguy7272]

Something like this should do it:
Sheets("Budget").Select or Sheets(3).Select

Look at this reference (it even uses the same name you use in your Workbook):
http://www.ozgrid.com/VBA/excel-vba-sheet-names.htm

Ryan---