$$Excel-Macros$$ VBA Code for Hide specific column as per criteria

2014-01-01 Thread amar takale
Dear Experts Pls help me on this topic.All detailed give in excel attached. Regards Amar T -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

$$Excel-Macros$$ Excel Charts Gallery

2014-01-01 Thread mrExcel4u
Hi All Visit for Excel Chart Gallery. Excel Charts Gallery Thanks & regards, Vikas Verma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/dis

$$Excel-Macros$$ Re: Find Item in combobox

2014-01-01 Thread Basole
Hi Mr., sorry try this now: Private Sub UserForm_Initialize() Dim contA As Integer Dim contP As Integer Dim small As String Dim Elm As Integer Elm = ComboBox1.ListCount For contA = 0 To Elm - 2 For contP = contA + 1 To Elm - 1 If ComboBox1.List(contA) >

Re: $$Excel-Macros$$ Re: Find Item in combobox

2014-01-01 Thread Rupesh Patil
Thanks Basole Sir for response this is not working On Wed, Jan 1, 2014 at 8:46 PM, Basole wrote: > Hi Rp,try this other option: > > > > Private Sub UserForm_Initialize() > Dim contA As Integer > Dim contP As Integer > Dim small As String > Dim Elm As Integer > Elm = ComboBo

$$Excel-Macros$$ Re: Find Item in combobox

2014-01-01 Thread Basole
Hi Rp,try this other option: Private Sub UserForm_Initialize() Dim contA As Integer Dim contP As Integer Dim small As String Dim Elm As Integer Elm = ComboBox1.ListCount For contA = 0 To Elm - 2 For contP = contA + 1 To Elm - 1 If ComboBox1.List(contA)

Re: $$Excel-Macros$$ Find Item in combobox

2014-01-01 Thread Rupesh Patil
can any buddy help me here. On Wed, Jan 1, 2014 at 4:42 PM, Rupesh Patil wrote: > Thanks you for looking into my problem, I am really appreciate for your > time, > But that is not exactly same what I am looking for. may be I was't clear > enough. > > what i wants is that if i enter "B" then all

$$Excel-Macros$$ E-Books free

2014-01-01 Thread mrExcel4u
Hi All, Download e-books free Warm regards, -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accura

Re: $$Excel-Macros$$ Find Item in combobox

2014-01-01 Thread Rupesh Patil
Thanks you for looking into my problem, I am really appreciate for your time, But that is not exactly same what I am looking for. may be I was't clear enough. what i wants is that if i enter "B" then all the item present in the drop down come first which started with "B" and i have only one combo

$$Excel-Macros$$ Excel & VBA

2014-01-01 Thread mrExcel4u
Hi All, Must visit below mentioned ... Happy New Year 2014 Thanks & regards, -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel F

$$Excel-Macros$$ Find Item in combobox

2014-01-01 Thread Rupesh Patil
Hi Experts, I have one combox with 1000 items, What i want is find item in that combo box, suppose user enter "B" then item come in drop down all started with "B" if Ba then start with "Ba" list come Thanks in advance -- Thanks and Regards, Rp. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exce