Validating data in a spreadsheet control
 

Hi,

I'm designing a userform for others to capture data which I feel offer
the best option for security (the potential users aren't v. skilled) bu
I need to add a spreadsheet control to the userform to capture approx 2
rows of repetitive data. The cells in each row need to be strictl
validated and/or have choices limited to values in dropdown lists. I
this possible with a spreadsheet control?

Unfortunately because of corporate policy I'm tied to developing wit
Excel and using an Excel worksheet in the past to accomplish the abov
has met with hazards as users have either cut/paste or dragged unlocke
input cells around previous forms :mad:

Many thank

--
Nuncl
-----------------------------------------------------------------------
Nuncle's Profile: http://www.excelforum.com/member.php...fo&userid=1487
View this thread: http://www.excelforum.com/showthread.php?threadid=26498