Hai everyone
I attached an excel sheet which contains a form. In that I placed three
nos. of combo boxes. Each have its values.
when I change the gp combo value the remaining two combo values should
automatically change.
I tried in many ways but failed.
please help me out.
regards
shankar sb
Dear Seniors,
Thank to all of you. Your help means a lot for me. thanks.
thanks,
Ashish
On Monday, July 22, 2013 11:44:56 AM UTC+5:30, Vabz wrote:
>
> Hi,
>
> It is working fine. In Cell A3 data is 958321.1 which is reversed
> as 1.123859.
>
> Pl check & confirm.
>
> T
Dear VBA,
Thanks for your help and valuable support. this is woking fine.
Thanks,
Ashish
On 22 July 2013 11:44, vba wrote:
> Hi,
>
> It is working fine. In Cell A3 data is 958321.1 which is reversed
> as 1.123859.
>
> Pl check & confirm.
>
> Thanks!!
>
>
> On Mon, Jul 22, 2013
Hi,
It is working fine. In Cell A3 data is 958321.1 which is reversed
as 1.123859.
Pl check & confirm.
Thanks!!
On Mon, Jul 22, 2013 at 10:55 AM, Ashish Kumar wrote:
> Dear VbA,
>
> thanks for your help. but this formula is not working properly.
>
>
> Thanks,
> Ashish
>
>
> On
Dear Expert ,
Can you expline the bold line as i want to know deeply.
Function Reverse(Text As String) As String
Dim i As Integer
Dim StrNew As String
Dim strOld As String
strOld = Trim(Text)
For i = 1 To Len(strOld)
* StrNew = Mid(strOld, i, 1) & StrNew*
Next i
R
Dear VbA,
thanks for your help. but this formula is not working properly.
Thanks,
Ashish
On 22 July 2013 10:27, vba wrote:
> PFA
>
> Thanks
>
>
> On Sun, Jul 21, 2013 at 11:10 PM, Ashish Kumar
> wrote:
>
>> Dear Vabs,
>>
>> Thanks for you reply, the formula is working but when I change this
PFA
Thanks
On Sun, Jul 21, 2013 at 11:10 PM, Ashish Kumar wrote:
> Dear Vabs,
>
> Thanks for you reply, the formula is working but when I change this
> formula accordingly this is not working properly. please find attached
> excel sheet for query data.
>
>
> On 21 July 2013 21:20, vba wrote:
>
Dear Vabs,
Thanks for you reply, the formula is working but when I change this formula
accordingly this is not working properly. please find attached excel sheet
for query data.
On 21 July 2013 21:20, vba wrote:
> Hey,
>
> Try this, this works up to 12 character.
>
> =IF(LEN(B1)<1,"",MID(B1,LE
Hi Ashish,
Try this
Function Reverse(Text As String) As String
Dim i As Integer
Dim StrNew As String
Dim strOld As String
strOld = Trim(Text)
For i = 1 To Len(strOld)
StrNew = Mid(strOld, i, 1) & StrNew
Next i
Reverse = StrNew
End Function
.
try this udf
Function revr(s As String)
revr = StrReverse(s)
End Function
On Sun, Jul 21, 2013 at 7:51 PM, Ashish Kumar wrote:
> Dear Seniors,
>
> I have this type of data :
>
> 54321
> ASDF
> 8796564
> DFRESW
>
> But I want OUTPUT like below mentioned :
>
> 12345
> FDSA
> 4656978
> WSERFD
Hey,
Try this, this works up to 12 character.
=IF(LEN(B1)<1,"",MID(B1,LEN(B1),1))&
IF(LEN(B1)<2,"",MID(B1,LEN(B1)-1,1))&
IF(LEN(B1)<3,"",MID(B1,LEN(B1)-2,1))&
IF(LEN(B1)<4,"",MID(B1,LEN(B1)-3,1))&
IF(LEN(B1)<5,"",MID(B1,LEN(B1)-4,1))&
IF(LEN(B1)<6,"",MID(B1,LEN(B1)-5,1))&
IF(LEN(B1)<7,"",MID(B1,L
Dear Ashish sir,
thanks for your quick response, but this is not working & i want solve this
query only from excel formula not VbA. coz, i want to reverse string in
some columns not whole excel sheet. please suggest me how to resolve this
query from excel formula.
Thanks,
Ashish
On Sunday, J
hi
visit this link http://www.rondebruin.nl/win/s1/outlook/mail.htm
you will find multiple options for sending email automatically using macros
On Sat, Jul 20, 2013 at 6:54 PM, dynamitekicker wrote:
> Thanks Ashish! Word mail merge is a satisfactory solution, but ultimately
> I would still ne
Dear Seniors,
I have this type of data :
54321
ASDF
8796564
DFRESW
But I want OUTPUT like below mentioned :
12345
FDSA
4656978
WSERFD
How to make ti reversal through formula. Please help ??
Thanks & Regards,
Ashish Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wan
http://redwood-hotel.com/qvm/syfyvhrfeh
prasadpain
7/21/2013 2:00:21 PM
--
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 RU
http://dooncarryingcompany.com/ibeablao/zdukok.enfj
--
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, accurate thread titles. Poor thr
Hi
Pl refer. http://chandoo.org/wp/2009/11/17/group-dates-in-pivot-tables/
Thanks
On Friday, July 5, 2013 6:03:30 PM UTC+5:30, Krishnaraddi V. Madolli wrote:
>
> Does anyone know how to group dates into months in a Pivot table in
> Excel *2003*?
>
>
>
> Regards,
>
> Krishnaraddi V Madolli.
>
17 matches
Mail list logo