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 |
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 |
All times are GMT +1. The time now is 12:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com