ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to create Checkboxex on the fly (https://www.excelbanter.com/excel-programming/406106-how-create-checkboxex-fly.html)

Madiya

How to create Checkboxex on the fly
 
I have a list box populated with amounts.
I want to create a checkbox for each items in listbox with checkbox
caption as amount on the fly.
Pl suggest the best way for the same.
Pl note that once the user selects the checkboxes, I need to process
all the selected checkboxes.

Regards,
Madiya

Bob Phillips

How to create Checkboxex on the fly
 
Best way? Don't.

Create more than you need and hide them, unhiding those you need as you need
them.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Madiya" wrote in message
...
I have a list box populated with amounts.
I want to create a checkbox for each items in listbox with checkbox
caption as amount on the fly.
Pl suggest the best way for the same.
Pl note that once the user selects the checkboxes, I need to process
all the selected checkboxes.

Regards,
Madiya




Madiya

How to create Checkboxex on the fly
 
On Feb 14, 7:51*pm, "Bob Phillips" wrote:
Best way? Don't.

Create more than you need and hide them, unhiding those you need as you need
them.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Madiya" wrote in message

...



I have a list box populated with amounts.
I want to create a checkbox for each items in listbox with checkbox
caption as amount on the fly.
Pl suggest the best way for the same.
Pl note that once the user selects the checkboxes, I need to process
all the selected checkboxes.


Regards,
Madiya- Hide quoted text -


- Show quoted text -


Hi Bob,
Thanks for your reply.
I certainly value your openion as you are a regular responder to so
many people with very good accuracy.

Let me explain my problem.
Based on certain criteria, I have filtered the database in the excel
sheet.
I want to give a choice to user based on the filtered values.
My plan was to create the checkboxes on the fly (one for each filtered
value).
User selects the options i.e. checkbox which he wants to process.
I will loop thru all the check boxes and process only those which are
checked.

In this senario, what other options are available?
Can you please point out alternate ways to avoid on the fly checkboxes
please?

Regards,
Madiya.


All times are GMT +1. The time now is 03:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com