Linking 2 drop boxes by a macro

[narenr]

Hi,

I have made a drop box to select pipe diameter, based on the selected diameter, I need to have another drop box to pick from a list of wall thickness.

Question: If I link a macro to the pipe diameter to create a drop box list of wall thickness, will it work?

 

[WMO]

If you are doing this in the spreadsheet itself and not with vba then look here:

http://www.contextures.com/xlDataVal02.html

-Mark

 

[narenr]

Mark, since it involves a conditional selection, I have used VBA, is there a similar reference?

Narendranath R
Pipeline engineering is made easy with state of the art computer software, visit

http://www.narendranath.itgo.com.

 

[prost]

Link

http://www.contextures.com/xlDataVal02.html

doesn't seem to work.

 

[prost]

Must be a temporary problem; I googled and found a zillion references to "

http://www.contextures.com,"

most of which were highly complimentary of what appears to be an excellent free resource for Excel manipulations.

 

[WMO]

On a userform?
Please elaborate.

-Mark

 

[narenr]

Thanks all, I actually solved the issue.

It was simple, I created a dropdown list [dd1] for pipe dia and another dropdown list [dd2] for wallthickness. I assigned a macro to lookup for the wallthickness avialable for the selected pipe dia to dd1.

The initial problem I had was a syntax error which I overlooked.

Narendranath R
Pipeline engineering is made easy with state of the art computer software, visit

http://www.narendranath.itgo.com.

 

[prost]

http://www.contextures.com/xlDataVal02.html

works now (Friday morning)