if you have 3 userform comboboxes and enter data in first box how can you code it so that if i enter same data in 2nd box or 3rd box it can not enter the same data dont know if it would be a lookup ect ,
colin
if you have 3 userform comboboxes and enter data in first box how can you code it so that if i enter same data in 2nd box or 3rd box it can not enter the same data dont know if it would be a lookup ect ,
colin
demo file using a couple of sheets from your previous posting - the three comboboxes check their choices against each other and also check whether the selection has been issued in the 'ISSUED' sheet.
when setting out your sheets where possible keep common headers in the same columns - if there is no justifiable reason do not colour or format your data storage sheet it can slow down data manipulation.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
hi
thanks thats brilliant just what i wanted ,
have just found this aswell that sends it to sheetPlease Login or Register to view this content.
many thanks colin
not sure how to put solved on now its been awhile
colin
hi
looking at it looks like your way is way to go think mine will be a bit long winded
many thanks colin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks