Re: Re: Re: Re: $$Excel-Macros$$ Font size in drop-down menu

2011-11-10 Thread Sam Mathai Chacko
By the way, the code to Zoom the window is ActiveWindow.Zoom= 120 which means 120% Regards, Sam On Thu, Nov 10, 2011 at 10:54 PM, Sam Mathai Chacko wrote: > You CAN increase the font size if it is an Activex Control. Form Controls > like mentioned earlier, don't allow font size increase or decr

Re: Re: Re: Re: $$Excel-Macros$$ Font size in drop-down menu

2011-11-10 Thread Sam Mathai Chacko
You CAN increase the font size if it is an Activex Control. Form Controls like mentioned earlier, don't allow font size increase or decrease. Regards, Sam On Thu, Nov 10, 2011 at 9:50 PM, Mahreen Ellahi wrote: > Nop didnt get the desired result, anyways m making a new sheet with 100% > zoom and

Re: Re: Re: Re: $$Excel-Macros$$ Font size in drop-down menu

2011-11-10 Thread Mahreen Ellahi
Nop didnt get the desired result, anyways m making a new sheet with 100% zoom and its working thanks Mahreen On Thu, Nov 10, 2011 at 7:49 PM, wrote: > For example, with Data Validation cells in column D: > Private Sub Worksheet_SelectionChange(ByVal Target As Range) > If Target.Count > 1 Then E

Re: Re: Re: Re: $$Excel-Macros$$ Font size in drop-down menu

2011-11-10 Thread waheedbaba
For example, with Data Validation cells in column D: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Target.Column = 4 Then Target.Columns.ColumnWidth = 20 Else Columns(4).ColumnWidth = 5 End If End Sub To add this code to the worksheet: Right-cli

Re: Re: Re: $$Excel-Macros$$ Font size in drop-down menu

2011-11-10 Thread Mahreen Ellahi
Any code? On Thu, Nov 10, 2011 at 3:55 PM, wrote: > Well u can use the code mentioned in the link to make it zoom a bit > > On , Mahreen Ellahi wrote: > > Thanks :-( > > > > > > > > On Thu, Nov 10, 2011 at 3:43 PM, waheedb...@gmail.com> wrote: > > > > > > Hi, > > Its fixed size you cant cha

Re: Re: Re: $$Excel-Macros$$ Font size in drop-down menu

2011-11-10 Thread waheedbaba
Well u can use the code mentioned in the link to make it zoom a bit On , Mahreen Ellahi wrote: Thanks :-( On Thu, Nov 10, 2011 at 3:43 PM, waheedb...@gmail.com> wrote: Hi, Its fixed size you cant change it. Plz refer the below link http://www.contextures.com/xldataval08.html O

Re: Re: $$Excel-Macros$$ Font size in drop-down menu

2011-11-10 Thread Mahreen Ellahi
Thanks :-( On Thu, Nov 10, 2011 at 3:43 PM, wrote: > Hi, > Its fixed size you cant change it. > Plz refer the below link > http://www.contextures.com/xldataval08.html > > On , Mahreen Ellahi wrote: > > I ve already gone through this link, thanks. But i dont ve a combo box, > i ve used data vali

Re: Re: $$Excel-Macros$$ Font size in drop-down menu

2011-11-10 Thread waheedbaba
Hi, Its fixed size you cant change it. Plz refer the below link http://www.contextures.com/xldataval08.html On , Mahreen Ellahi wrote: I ve already gone through this link, thanks. But i dont ve a combo box, i ve used data validation. On Thu, Nov 10, 2011 at 3:27 PM, waheedb...@gmail.com>

Re: $$Excel-Macros$$ Font size in drop-down menu

2011-11-10 Thread Mahreen Ellahi
I ve already gone through this link, thanks. But i dont ve a combo box, i ve used data validation. On Thu, Nov 10, 2011 at 3:27 PM, wrote: > Hi, > Please refer the link > http://www.contextures.com/xlDataVal10.html > > Regards, > waheed > On , Mahreen Ellahi wrote: > > Can anybody tell me how

Re: $$Excel-Macros$$ Font size in drop-down menu

2011-11-10 Thread waheedbaba
Hi, Please refer the link http://www.contextures.com/xlDataVal10.html Regards, waheed On , Mahreen Ellahi wrote: Can anybody tell me how to increase font size in drop down menu like when a user selects the menu, the options are too small and not visible. regards Mahreen