How do I find what is in a spreadsheet

[zigzagdna]

Subject: How do I find what is in a spreadsheet

I see a spreadsheet (which I inherited from some one). Spreadsheet has radio buttons, pop-up list, charts. When you select a radio button, certain charts show up …
However when I go to Visual Basic Editor, I do not see any form. I only seeunder excel objects, sheet name. I wonder where exactly logic for selecting a radio button or pop-up list is written when VB editor does not show anything other than sheet name.

Thanks.
Prem

 

[Spencer101]

Subject: How do I find what is in a spreadsheet

I see a spreadsheet (which I inherited from some one). Spreadsheet ha
radio buttons, pop-up list, charts. When you select a radio button
certain charts show up …
However when I go to Visual Basic Editor, I do not see any form. I onl
see under excel objects, sheet name. I wonder where exactly logic fo
selecting a radio button or pop-up list is written when VB editor doe
not show anything other than sheet name.

Thanks.
Prem

Hidden worksheets

 

[RB Smissaert]

Look in the ThisWorkbook module or right-click that button and do Assign
Macro.

RBS


Subject: How do I find what is in a spreadsheet

I see a spreadsheet (which I inherited from some one). Spreadsheet has
radio buttons, pop-up list, charts. When you select a radio button, certain
charts show up …
However when I go to Visual Basic Editor, I do not see any form. I only see
under excel objects, sheet name. I wonder where exactly logic for selecting
a radio button or pop-up list is written when VB editor does not show
anything other than sheet name.

Thanks.
Prem

 

[zigzagdna]

Subject: How do I find what is in a spreadsheet I see a spreadsheet (which I inherited from some one). Spreadsheet has radio buttons, pop-up list, charts. When you select a radio button, certain charts show up … However when I go to Visual Basic Editor, I do not see any form. I only see under excel objects, sheet name. I wonder where exactly logic for selecting a radiobutton or pop-up list is written when VB editor does not show anything other than sheet name. Thanks. Prem

Thanks. Sheet is not hidden. When I click right and view code, I do see some subroutines for checkbox, listbox, option button but there are empty. Also, in sheet itselect there is no way to add list, radio buttons etc (or is there a way, when I go to that worksheet and then click on isert in ribbon,it shows me textbox, graphic arts etc but no where I see list box, option button etc .. vba priject exploere does not show any code in Thisworkbook, under form or module realted to this sheet.

 

[RB Smissaert]

Could you post the workbook, so we can see?

RBS

Subject: How do I find what is in a spreadsheet I see a spreadsheet (which
I inherited from some one). Spreadsheet has radio buttons, pop-up list,
charts. When you select a radio button, certain charts show up … However
when I go to Visual Basic Editor, I do not see any form. I only see under
excel objects, sheet name. I wonder where exactly logic for selecting a
radio button or pop-up list is written when VB editor does not show
anything other than sheet name. Thanks. Prem

Thanks. Sheet is not hidden. When I click right and view code, I do see some
subroutines for checkbox, listbox, option button but there are empty. Also,
in sheet itselect there is no way to add list, radio buttons etc (or is
there a way, when I go to that worksheet and then click on isert in ribbon,
it shows me textbox, graphic arts etc but no where I see list box, option
button etc .. vba priject exploere does not show any code in Thisworkbook,
under form or module realted to this sheet.

 

[zigzagdna]

Subject: How do I find what is in a spreadsheet I see a spreadsheet (which I inherited from some one). Spreadsheet has radio buttons, pop-up list, charts. When you select a radio button, certain charts show up … However when I go to Visual Basic Editor, I do not see any form. I only see under excel objects, sheet name. I wonder where exactly logic for selecting a radiobutton or pop-up list is written when VB editor does not show anything other than sheet name. Thanks. Prem

I do now see that in Execl 2007, from developer, one can directly insert form and sctive controls is a spreadheet. For some reason, form controls do not show up in Excel code, but VBA controls do; however I am still not able to see any code other them empty subroutines!!!! Wonder why?