I'm looking to display a form that shows the results of a query in a list
box.

The trick is that I'd like command buttons to be made visible dependant upon
whether there is an equivalent member of the list, something on the lines of
(pseduo-code)

instead of CommandButton1, CommandButton2 etc

CommandButton(counter).visible = True

Is this possible?

Jeff

One way......

Setting the destination of the query to a worksheet and reading the contents
of this.
Not sure I know what you mean by 'Equivalent Member' but assume you mean
that the query returns values that you want to use test against a control
value. Need to understand exactly what you are trying to do, but you can
certainly make controls visible or not based on the results of the test.
Typically with

If value1 = value2 then CommandButton1.Visible=True

where value1 might be your test value and value2 a cell value from the
destination range

for example.
Cheers
Nigel

"Jeff Q" wrote in message
...
I'm looking to display a form that shows the results of a query in a list
box.

The trick is that I'd like command buttons to be made visible dependant
upon
whether there is an equivalent member of the list, something on the lines
of
(pseduo-code)

instead of CommandButton1, CommandButton2 etc

CommandButton(counter).visible = True

Is this possible?

Jeff






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

Hi Jeff,

CommandButton(counter).visible = True


Userform1.Controls("CommandButton" & counter).visible=True

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com