Y
yuqiaoyan
Hi,
I'm an amateur in terms of VBA programming. I'd like to implement a
design, but I'm not sure what's the best way to implement it. I'm
hoping people can provide some feedback.
Design:
Imagine a white square with a black border on the excel spreadsheet -
think of it as representing a blank HTML sheet. On the top there's a
Navigation Bar, and everything below holds content.
The Navigation Bar is 4 Words:
Home
Instructions
Credits
Tips
The Content will hold customized text boxes with varying amount of
description.
My Objective is so that when the User clicks on those Words the
content for each section will show up accordingly. This kind of
experience is somethign that occurs in many webpages. You click on a
link and it shows the content for each section
Implementation Ideas:
(1) Use Hyperlinking
I can place the Home from A10 to wherever it ends and then put the
Instructions from A100 to wherever it ends and so on and so forth. The
user will be able to reach the different sections fairly quickly in
the tab, but it's not the webpaging experience I'm looking for.
This requires no VBA
(2) Bring Back -> Bring Front
I'll place all the content on top of each other. When a user clicks
"Home" the text box with the Home's content will be brought to the
front. The biggest issue with this is if Home's section's text is
longer than the Tips section e.g. when I bring the Tips section to the
front I'll be able to see text from the Home section.
Are there any modifications I can make to the 2 ideas above to make it
more like the web page experience? Or does excel have a functionality
built in to create do this?
Thanks,
Qiao Yan
I'm an amateur in terms of VBA programming. I'd like to implement a
design, but I'm not sure what's the best way to implement it. I'm
hoping people can provide some feedback.
Design:
Imagine a white square with a black border on the excel spreadsheet -
think of it as representing a blank HTML sheet. On the top there's a
Navigation Bar, and everything below holds content.
The Navigation Bar is 4 Words:
Home
Instructions
Credits
Tips
The Content will hold customized text boxes with varying amount of
description.
My Objective is so that when the User clicks on those Words the
content for each section will show up accordingly. This kind of
experience is somethign that occurs in many webpages. You click on a
link and it shows the content for each section
Implementation Ideas:
(1) Use Hyperlinking
I can place the Home from A10 to wherever it ends and then put the
Instructions from A100 to wherever it ends and so on and so forth. The
user will be able to reach the different sections fairly quickly in
the tab, but it's not the webpaging experience I'm looking for.
This requires no VBA
(2) Bring Back -> Bring Front
I'll place all the content on top of each other. When a user clicks
"Home" the text box with the Home's content will be brought to the
front. The biggest issue with this is if Home's section's text is
longer than the Tips section e.g. when I bring the Tips section to the
front I'll be able to see text from the Home section.
Are there any modifications I can make to the 2 ideas above to make it
more like the web page experience? Or does excel have a functionality
built in to create do this?
Thanks,
Qiao Yan