Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TRICKY: runtime generated comboboxes and change event
keepITcool, Thanks for your reply. I am actually cleening up the collection in th deactivate sub. Besides that the amount of rows won't exceed 50. Validation won't work - The purpose is that I have a list of record and a status for each record (column 2) - the user shouldn't be able t edit any cell (perhaps with userinterface protection, but that's not topic yet), but just be able to change the status for records. as soo as he has done that with at least one record a commandbar button shoul be enabled... I didn't know that the activex controls generate files and so on perhaps there is a better approach based on the goal described above but which one ? cheers, pet -- Gopp ----------------------------------------------------------------------- Goppi's Profile: http://www.excelforum.com/member.php...fo&userid=1582 View this thread: http://www.excelforum.com/showthread.php?threadid=27314 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
TRICKY: runtime generated comboboxes and change event
if you dont want to give the user any editing capability.. i'd use a userform iso controls on a sheet. although you haven't convinced me that DataValidation wouldn't work in your situation. lock all cells except the 'status' field.. datavalidate (with list) the statusfield.. changeevent for the sheet triggers the commandbar activation ELSE: stick to native controls, forget embedded. ELSE have ONE CONTROL. (RE)position that on SelectionChange event keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool Goppi wrote: keepITcool, Thanks for your reply. I am actually cleening up the collection in the deactivate sub. Besides that the amount of rows won't exceed 50. Validation won't work - The purpose is that I have a list of records and a status for each record (column 2) - the user shouldn't be able to edit any cell (perhaps with userinterface protection, but that's not a topic yet), but just be able to change the status for records. as soon as he has done that with at least one record a commandbar button should be enabled... I didn't know that the activex controls generate files and so on - perhaps there is a better approach based on the goal described above - but which one ? cheers, pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Textbox added to Form at runtime too small, can't control size andchange event won't trigger | Excel Worksheet Functions | |||
Textbox added to Form at runtime too small, can't control size andchange event won't trigger | Excel Worksheet Functions | |||
TRICKY: runtime generated comboboxes and change event | Excel Programming | |||
User forms that are generated at runtime | Excel Programming | |||
How to code event for dynamically generated checkboxes | Excel Programming |