collapsible panel in a form - need help

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
2,053
Office Version
  1. 365
Platform
  1. Windows
I am trying to put in a collapsible panel into a form similar to that found half way down the page at: https://register.cc-hubwoo.com/CompanyInformation.aspx?

its the panel below "Select the Products & Services your company provides based on:" and for UNSPSC. these are united nations codes used to standardise goods and services purchased by companies. Would this be done using dependent drop down boxes or is there a better way?
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
There's definitely no such control that I know of that would give you this sort of functionality in 'standard' Excel VBA.

Are you just trying to simulate something lik eit?

I think using listboxes and comboboxes is the closest you'd get to that sort of thing, and yes they would probably be dependent.

I actually thing there might be a listview or even a treeview involved for the 'panel'.
 
Upvote 0
i would love to have this exact sort of thing but will settle happily for a simulation of it. we will eventually move to a web based solution but need something now to get us through. i'll have a search through my files for the lists/combos as its been a few jobs since i used them last.
 
Upvote 0
That's probably ajax at work at the website ;)

You *could* have a set of 2 or 3 dependent combos, with the second and third reloaded based on what's selected in the first...
 
Upvote 0
ajm

You could definitely create something but I don't think you would get the hiding part easily and I think you would need a screed of code for the animation.

If you would be happy with listboxes and comboxes it shouldn't be too hard, at least to display the data anyway.

You are kind of limited format wise.:)
xenou

Don't think you need AJAX.:)

I just created a treeview with several nodes in standard ASP, without an XML datasource - I justed added the nodes 'manually'.
 
Upvote 0

Forum statistics

Threads
1,223,952
Messages
6,175,593
Members
452,654
Latest member
mememe101

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
Back
Top