Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data validation - combo box susan Excel Worksheet Functions 4 May 23rd 08 11:44 PM
Data validation with validation lists and combo boxs Keith Excel Discussion (Misc queries) 1 October 12th 06 11:08 AM
hyperlink in combo box/data validation Dannycol Excel Worksheet Functions 0 April 4th 06 11:23 PM
List, Combo Box, Data Validation?? JackieR Excel Discussion (Misc queries) 1 November 22nd 05 04:09 PM
Combo Box or Data Validation FA Excel Discussion (Misc queries) 17 September 27th 05 01:58 PM


All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"