TRICKY: runtime generated comboboxes and change event

[Goppi]

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

 

[keepITcool]

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 >