You still need the forms and the Worksheet change code. We could do the
latter with application events, post the current code and we ca
convert. I
assume the forms can be in the add-in? where will the DV list be?
Thanks for the reply, I had given up hope!
I have the forms and the macro to add the necessary DV list, and hav
exported this as an addin...
lets say the user add's the "add-in" in to their brand new sheet, a
the moment nothing happens.... which i can understand... but how can
get the DV list to initialise and somehow embed the code on to the shee
to call the forms, or am i going about that the wrong way?
i.e at the moment the code for the form call (show) is on th
worksheet_change event, how could i get this to work from an add-i
perspective?
Thanks again :
--
ex130
-----------------------------------------------------------------------
ex1302's Profile:
http://www.excelforum.com/member.php...fo&userid=2521
View this thread:
http://www.excelforum.com/showthread.php?threadid=38707