Y
yuqiaoyan
Hi,
Sorry if this is a double post. I sent it earlier but it doesn't seem
to have shown up.
I'm an amateur VBA programmer looking for some feedback on how to
implement a specific design. I'm trying to create a "Webpage"
experience within one tab of an excel spreadsheet.
Imagine a White Square on a sheet with a black border. That's my
Webpage/Workspace if you will. On the top, there's a Navigation Bar,
and below that is my content space. When the user clicks on the Text
in each Cell of the Navigation Bar, relevant content will appear in
the white space.
Two Implementation Ideas:
(1) Use Hyperlinking Functionality Excel
I can place the content in different parts of the excel spreadsheet,
and then hyperlink the text to these parts. The problem with that is
you'll get a jumping experience each time. And if the user scrolls
around he'll see all the content rather than linking.
(2) Move Front Bring Back
I can place all the content on top of each other and then write a
macro using Move Front and Bring Back functionality. However if one of
the sections have a lot more content then another then when I bring
the shorter section to the front it will show the other sections
content.
Is there a way to modify these two ideas to create a closer experience
to Webpages? Or is there a different way to implement this that I can
try?
Thanks
Qiaoyan
Sorry if this is a double post. I sent it earlier but it doesn't seem
to have shown up.
I'm an amateur VBA programmer looking for some feedback on how to
implement a specific design. I'm trying to create a "Webpage"
experience within one tab of an excel spreadsheet.
Imagine a White Square on a sheet with a black border. That's my
Webpage/Workspace if you will. On the top, there's a Navigation Bar,
and below that is my content space. When the user clicks on the Text
in each Cell of the Navigation Bar, relevant content will appear in
the white space.
Two Implementation Ideas:
(1) Use Hyperlinking Functionality Excel
I can place the content in different parts of the excel spreadsheet,
and then hyperlink the text to these parts. The problem with that is
you'll get a jumping experience each time. And if the user scrolls
around he'll see all the content rather than linking.
(2) Move Front Bring Back
I can place all the content on top of each other and then write a
macro using Move Front and Bring Back functionality. However if one of
the sections have a lot more content then another then when I bring
the shorter section to the front it will show the other sections
content.
Is there a way to modify these two ideas to create a closer experience
to Webpages? Or is there a different way to implement this that I can
try?
Thanks
Qiaoyan