Is there a way to insert a control into a cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I understand how to create a control. Is there a way to insert a control into a cell? I have a timesheet already designed and want to have a couple of cascading drop lists inside cells listing stuff like customer account # ect. Right now it seems like a huge amount of work to resize the control box to be the same size as the cell underneath it

Thanks.
 
Rick, sounds like data validation might work for you, have a look here for
some details

http://www.contextures.com/xlDataVal01.html


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

RickS said:
I understand how to create a control. Is there a way to insert a control
Click to expand...
into a cell? I have a timesheet already designed and want to have a couple
of cascading drop lists inside cells listing stuff like customer account #
ect. Right now it seems like a huge amount of work to resize the control
box to be the same size as the cell underneath it.
 
Your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Back
Top