View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default data validation and combo box

Try experimenting with these two settings in the worksheet code.

.Width = Target.Width + 15
.Height = Target.Height + 5

Play with them until you lose sight of the DV arrow


Gord

On Sun, 28 Sep 2008 08:58:00 -0700, macataq
wrote:

Thanks for the quick responses
the only changes i made to the sheet was to change the number of rows (from
12 to 33)
the number of validation lists (from 2 to 1) and location of the list (from
j2:j8 and
L2:L13, to C73:c105)
i am probably missing something simple. the combo box works as it is
supposed to, it just not look right. and yes when i say "under" i should have
said behind. it sticks out past the edge of the combo box.

thanks again

Mac