Re: $$Excel-Macros$$ Mobile Deals:Amzon:15 Oct

2015-10-16 Thread Rupesh Patil
allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Gro

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2015-01-10 Thread Rupesh Patil
Yes Vaibhav This group is rocking. On Sun, Jan 11, 2015 at 9:24 AM, Vaibhav Joshi wrote: > Namaskar Rupeah Patil Bhau, > > Good to hear that, this group is always rocking. > > Cheers!! > On Jan 10, 2015 10:49 PM, "Rupesh Patil" > wrote: > >> Hello grou

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2015-01-10 Thread Rupesh Patil
Hello group members. I am Rupesh Patil, I am working with Ayushman. Pvt as CSE. I learnt so many Excel Formulas, VBA macros things from this group. Thanks thank you all groups members. On Sat, Jan 10, 2015 at 10:23 PM, Siegfried Schulte wrote: > Hello esteemed group members: > > I am

Re: Fwd: $$Excel-Macros$$ Happy New 2015

2015-01-01 Thread Rupesh Patil
Happy new year to all!!! On 01-Jan-2015 12:14 PM, "Sandeep Sharma" wrote: > Welcome and wish u Happy new year all Group members. > > > With Regards > Sandeep Kumar Sharma > > *“Always laugh when you can. It is cheap medicine.*” > > -- Forwarded message -- > From: Ganesh N > Date:

Re: $$Excel-Macros$$ Add control on button click

2014-12-21 Thread Rupesh Patil
er long time ! > > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Fri, Dec 19, 2014 at 6:00 PM, Rupesh Patil > wrote: > >> Hello Vaibhav, >> >> 2nd approach full fill my requirement. >> &

Re: $$Excel-Macros$$ Add control on button click

2014-12-19 Thread Rupesh Patil
; > Since you have not shared your comlete requirement pl let us know which > method suits you... > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Fri, Dec 19, 2014 at 1:31 PM, Rupesh Patil > wrote: >> >> Hello Va

Re: $$Excel-Macros$$ Add control on button click

2014-12-19 Thread Rupesh Patil
id not do this for you. God is here working through me for you.* > > On Thu, Dec 18, 2014 at 11:33 PM, Rupesh Patil > wrote: >> >> How to add controls on every time button click >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

$$Excel-Macros$$ Add control on button click

2014-12-18 Thread Rupesh Patil
How to add controls on every time button click -- 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 thread t

Re: $$Excel-Macros$$ Add and remove text box on ever time button click.

2014-11-26 Thread Rupesh Patil
of! > > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----

Re: $$Excel-Macros$$ Add and remove text box on ever time button click.

2014-11-19 Thread Rupesh Patil
m? > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - Jo

Re: $$Excel-Macros$$ Add and remove text box on ever time button click.

2014-11-19 Thread Rupesh Patil
Please Experts help me out. On Tue, Nov 18, 2014 at 5:07 PM, Rupesh Patil wrote: > Hello Experts, > > any help? > > > On Mon, Nov 17, 2014 at 4:10 PM, Rupesh Patil > wrote: > >> Hello experts, >> >> I need your help,I have one userform which attach

Re: $$Excel-Macros$$ Add and remove text box on ever time button click.

2014-11-18 Thread Rupesh Patil
Hello Experts, any help? On Mon, Nov 17, 2014 at 4:10 PM, Rupesh Patil wrote: > Hello experts, > > I need your help,I have one userform which attached with mail for your > reference, what I need is add text boxes vertical on button every time > click "Add Button" a

$$Excel-Macros$$ Add and remove text box on ever time button click.

2014-11-17 Thread Rupesh Patil
n sheet. -- Thanks & Regards, Rupesh Patil, (9970196189) ​.​ -- 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 ti

$$Excel-Macros$$ Port VBA code to VB.net

2014-10-09 Thread Rupesh Patil
hanks & Regards, Rupesh Patil, (9970196189), Ayushman Pvt. Ltd. -- 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 tit

$$Excel-Macros$$ Excel to JSON

2014-09-16 Thread Rupesh Patil
​Hello Expert, I need your help VBA macro. I have excel file, this file has 10 to 25 user's records​, each user has 414 column records(A:OX) what I want is that convert excel row of each user record to JSON. -- Thanks & Regards, Rupesh Patil, (9970196189), Ayushman Pvt. Ltd. -- Are

Re: $$Excel-Macros$$ Validate Email Id

2014-09-12 Thread Rupesh Patil
Sep 12, 2014 at 10:28 AM, Rupesh Patil > wrote: > >> >> ​Hello expert, >> >> ​I need macro for validate email id. >> following is email id format >> >> anyword.deptn...@dome.ac.in >> >> I have above mails ids format, what validations i nee

Re: $$Excel-Macros$$ Validate Email Id

2014-09-12 Thread Rupesh Patil
Hello Expert, Does anybody have any idea how to do this. Please help On Fri, Sep 12, 2014 at 10:28 AM, Rupesh Patil wrote: > > ​Hello expert, > > ​I need macro for validate email id. > following is email id format > > anyword.deptn...@dome.ac.in > > I have a

$$Excel-Macros$$ Validate Email Id

2014-09-11 Thread Rupesh Patil
il id(after "anyword.") if "deptname" not present then mail id is wrong if "deptname" present in mail id then compare it with array's value. if match in then mail is is correct else wrong array value are arr(&quo

$$Excel-Macros$$ save active sheet in new workbook

2014-09-10 Thread Rupesh Patil
Hello Expert, I need your help. I need VBA Macro. How to save active sheet to new workbook with same sheet name in specific location. -- Thanks & Regards, Rupesh Patil, -- 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 Face

$$Excel-Macros$$ Macros get deleted

2014-09-08 Thread Rupesh Patil
​Hello Experts I am using office 2013, when download any macro included workbook from this group macro get deleted when open this workbook. could any one why this happen. Thanks in advance ​ -- Thanks & Regards, Rupesh Patil, -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you w

Re: $$Excel-Macros$$ Transpose data

2014-08-31 Thread Rupesh Patil
Hi Vaibhav, Very very thanks, it is working as expected. Thanks and regards Rupesh On Sun, Aug 31, 2014 at 12:44 PM, Vaibhav Joshi wrote: > Cheers Bro.. > > Check this it has macro, i assume if lines are in millions than formula > will get slower.. > > Click run macro, select input sheet ha

Re: $$Excel-Macros$$ Transpose data

2014-08-30 Thread Rupesh Patil
> excel-macros@googlegroups.com] *On Behalf Of *Rupesh Patil > *Sent:* Saturday, August 30, 2014 3:08 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Transpose data > > > > Dear Expert, > > > > I need one micro or formula which transpose data. &g

$$Excel-Macros$$ Transpose data

2014-08-30 Thread Rupesh Patil
Dear Expert, I need one micro or formula which transpose data. Sample file attach with mail with explanation. please help me out Thanks and regards Rupesh -- 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 fo

Re: $$Excel-Macros$$ Add Control On button click on Page

2014-07-15 Thread Rupesh Patil
> *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Rupesh Patil > *T

Re: $$Excel-Macros$$ Add Control On button click on Page

2014-07-15 Thread Rupesh Patil
times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Rupesh Patil > *To:* excel-macros@googlegroups.com > *Sent:* Monday, July 14, 2014 6:52 AM > *Subject:* Re: $$Excel-Macros$$ Add Control On button click

Re: $$Excel-Macros$$ Add Control On button click on Page

2014-07-14 Thread Rupesh Patil
Hello Expert, Please help On Sun, Jul 13, 2014 at 3:44 PM, Rupesh Patil wrote: > Any suggestions > Experts > On 12-Jul-2014 11:33 AM, "Rupesh Patil" > wrote: > >> >> ​Hello Expert, >> >> I need a help from you. I want ​to add textbox on pa

Re: $$Excel-Macros$$ Add Control On button click on Page

2014-07-13 Thread Rupesh Patil
Any suggestions Experts On 12-Jul-2014 11:33 AM, "Rupesh Patil" wrote: > > ​Hello Expert, > > I need a help from you. I want ​to add textbox on page when each time > button click and add rows in excel for that textbox. > > I have attache sample file with this mail

$$Excel-Macros$$ Add Control On button click on Page

2014-07-11 Thread Rupesh Patil
​Hello Expert, I need a help from you. I want ​to add textbox on page when each time button click and add rows in excel for that textbox. I have attache sample file with this mail. There is two page on user form, On prescription page there are four text boxes, I wanted to add textbox on "New Dru

Re: $$Excel-Macros$$

2014-07-09 Thread Rupesh Patil
*“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Rupesh Patil > *To:* excel-macros@goog

$$Excel-Macros$$

2014-07-09 Thread Rupesh Patil
Hello Expert, I am confuse about the following question. * Can we record a looping statement ? Give some examples of looping statements ?* *Ans:* No. For loop, Do While Loop, Do Until Loop ​I am referring interview questions on one site . could any one please share some thought about the abov

Re: $$Excel-Macros$$ Loop through

2014-04-27 Thread Rupesh Patil
Dear Pramod, Thanks you very very much. On Mon, Apr 28, 2014 at 11:19 AM, Pramod Singh wrote: > Hi Rupesh, > > Please find the attached file. as per ur requirement. > > Regards/Pramod > > > > On Mon, Apr 28, 2014 at 10:03 AM, Rupesh Patil > wrote: > >>

$$Excel-Macros$$ Loop through

2014-04-27 Thread Rupesh Patil
Hello Expert, Good Morning I need your help, I am not able to determine how to loop through only till last used row and column, sample file is attachment, Please go through it and help me out. -- Thanks and Regards, Rp. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

Re: $$Excel-Macros$$ Convert JSON to VBA array

2014-04-22 Thread Rupesh Patil
",0,""NULL""],[""N"",""string"",0,""NULL""],[""O"",""string"",0,""NULL""],[""P"",""string"",0,""NULL""],[""Q"",""stri

$$Excel-Macros$$ Convert JSON to VBA array

2014-04-21 Thread Rupesh Patil
Hello Experts, I need your help, I need to convert Json(output return from webservice) to Array. following is json output [["A","string",0,"NULL"],["B","string",0,"NULL"],["C","string",0,"NULL"],["D","string",0,"NULL"],["E","string",0,"isemail"],["F","string",0,"ismobile"],["G","string",0,"NULL"]

Re: $$Excel-Macros$$ concatenation url

2014-04-21 Thread Rupesh Patil
rom:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rupesh Patil > *Sent:* Monday, April 21, 2014 2:53 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ concatenation url > > > > Hello Expert, > > > > How to

$$Excel-Macros$$ concatenation url

2014-04-21 Thread Rupesh Patil
Hello Expert, How to invoke webservice with username and password VBA micro. Please help me out, I am using following code Dim MyRequest As Object Set MyRequest = CreateObject("WinHttp.WinHttpRequest.5.1") MyRequest.Open "POST", " http://192.168.1.111/ayushman/ws/validate

Re: $$Excel-Macros$$ parse .xsd file

2014-04-08 Thread Rupesh Patil
Hi expert, is there any solutions on it. On Tue, Apr 8, 2014 at 12:33 PM, Rupesh Patil wrote: > Hello Expert, > How to parse .xsd file in VBA. Please help > > -- > Thanks and Regards, Rp. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? I

Re: $$Excel-Macros$$ Validate excel from .xsd shcema

2014-04-08 Thread Rupesh Patil
Hi expert, is it possible? On Tue, Apr 8, 2014 at 11:59 AM, Rupesh Patil wrote: > Hi Expert, > > I need your fover. let me explain you context. > First I need to call web service from excel, > I have to pass username and password to this web service, > after user is va

$$Excel-Macros$$ parse .xsd file

2014-04-08 Thread Rupesh Patil
Hello Expert, How to parse .xsd file in VBA. Please help -- Thanks and Regards, Rp. -- 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

$$Excel-Macros$$ Validate excel from .xsd shcema

2014-04-07 Thread Rupesh Patil
Hi Expert, I need your fover. let me explain you context. First I need to call web service from excel, I have to pass username and password to this web service, after user is validate .xsd schema well be download and stored locally. in this .xsd schema there is some validation rules. then I n

$$Excel-Macros$$ Validate Excel sheet from .xsd schema

2014-04-03 Thread Rupesh Patil
Hello Expert, I need your help, I have one excel sheet this sheet come from different users this sheet have same structure. In my project, I have to upload it to database. before upload I have some set of validations. for validation we have written in .xsd schema. in this schema we define some set

Re: $$Excel-Macros$$ Validation on button click

2014-04-02 Thread Rupesh Patil
Dear Ravinder, Thanks but provided micro is not working as requirement. On Thu, Apr 3, 2014 at 12:15 PM, Ravinder wrote: > pfa > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rupesh Patil > *Sent:* Thursday, April 03

$$Excel-Macros$$ Validation on button click

2014-04-02 Thread Rupesh Patil
Hello Experts, I need your kind, I have attache sheet with my requirement, Please find in attachment. -- Thanks and Regards, Rp. -- 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.facebo

Re: $$Excel-Macros$$ Extract only text from alphanumeric string

2014-03-27 Thread Rupesh Patil
PFA, On Thu, Mar 27, 2014 at 8:19 PM, Capt. Jack Sparrow wrote: > Hi Team, > > I need to extract only the text from the alphanumeric string, can you > please help me with a formula. > > Sample data attached > > 12Mum159 Mum 46Kol2335 Kol 63Ch270 Ch 180Del307 De > > Regards, > > > -- > Ar

Re: $$Excel-Macros$$ Validation cells

2014-03-13 Thread Rupesh Patil
On Thu, Mar 13, 2014 at 3:57 PM, Ravinder wrote: > Pfa... try this may be you like.I have put data validation till 20th row > you can increased as per your requirement. > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behal

$$Excel-Macros$$ Validation cells

2014-03-12 Thread Rupesh Patil
Hello Expert, Good Morning I need your help, I have attached excel Sheet with my requirements Thanks in advance -- 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

Re: $$Excel-Macros$$ cell tooltip

2014-03-08 Thread Rupesh Patil
ame2.AutoSize = msoAutoSizeShapeToFitText > .TextFrame2.WordWrap = True > End With > End If > > End Sub > > > > On Sat, Mar 8, 2014 at 12:32 PM, Rupesh Patil > wrote: > >> Dear Abhishek, >> >> I have database for medicines, that data

Re: $$Excel-Macros$$ cell tooltip

2014-03-07 Thread Rupesh Patil
p when it is already visible in the Cell itself? Do you mean Cell > Address instead of Cell Value? > > Example - > > Cell Value is "Rupesh" > Cell Address is "E2" > > What do you want to appear in the tool tip? > > > > > > On Fri, Mar

Re: $$Excel-Macros$$ cell tooltip

2014-03-07 Thread Rupesh Patil
Hi Expert, Is there no way to do that? On Fri, Mar 7, 2014 at 9:57 AM, Rupesh Patil wrote: > Hi Expert, > > I need your help. how to show cell value as tool tip when mouse over that > cell. > > -- > Thanks and Regards, Rp. > > -- > Are you =EXP(E:RT) or =NOT(E

Re: $$Excel-Macros$$ Need micro

2014-03-06 Thread Rupesh Patil
Hi Ashish, that is not solution for my problem. thanks your valuable time On Fri, Mar 7, 2014 at 12:23 PM, Ashish Kumar wrote: > Hi Rupesh, then go with abhishek's formula. > > Thanks > Ashish > > > > On 7 March 2014 12:19, Rupesh Patil wrote: > >> Thanks

Re: $$Excel-Macros$$ Need micro

2014-03-06 Thread Rupesh Patil
Thanks Ashish your quick reply, but I want cut last 6 characters from column 'A' and paste it to column"B" On Fri, Mar 7, 2014 at 12:12 PM, Ashish Kumar wrote: > Hi Rupesh, > > PFA > > > Thanks > Ashish > > On 7 March 2014 11:57, Rupesh Patil w

Re: $$Excel-Macros$$ Need micro

2014-03-06 Thread Rupesh Patil
Thanks your quick reply, but I want cut last 6 characters from column 'A' and paste it to column"B" On Fri, Mar 7, 2014 at 12:08 PM, Abhishek Jain wrote: > In B2 - > > =RIGHT(A2,6) > > and drag down. > > HTH > > > On Fri, Mar 7, 2014

$$Excel-Macros$$ Need micro

2014-03-06 Thread Rupesh Patil
Hi Expert, Please find file in attachment -- Thanks and Regards, Rp. -- 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 thre

$$Excel-Macros$$ cell tooltip

2014-03-06 Thread Rupesh Patil
Hi Expert, I need your help. how to show cell value as tool tip when mouse over that cell. -- Thanks and Regards, Rp. -- 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/discus

Re: $$Excel-Macros$$ Dependent Combo box

2014-02-23 Thread Rupesh Patil
> excel-macros@googlegroups.com] *On Behalf Of *Rupesh Patil > *Sent:* Saturday, February 22, 2014 4:51 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Dependent Combo box > > > > Hi Expert, > > > > I need your help, I have one multipage with 11

Re: $$Excel-Macros$$ Dependent Combo box

2014-02-23 Thread Rupesh Patil
, ashish koul wrote: > Private Sub cb_all_Change() > Dim cnt As Control > > If Me.cb_all.Value = "Yes" Then > For Each cnt In Me.Controls > If TypeName(cnt) = "ComboBox" Then > cnt.Value = Me.cb_all.Value > End If > Ne

$$Excel-Macros$$ Dependent Combo box

2014-02-22 Thread Rupesh Patil
Hi Expert, I need your help, I have one multipage with 11 combo boxes. all combo box have same value, value are "Yes", "No", "Don't No". there is one combo box called "All" what I want is that suppose user select("Yes") value from "All" combo box, other combo boxes value should be same ("Yes") as

Re: $$Excel-Macros$$ Excel micro

2014-02-22 Thread Rupesh Patil
Thanks Ashish your replay. I have solved my problem. thanks again On Sat, Feb 22, 2014 at 3:32 PM, ashish koul wrote: > can you share a sample file > > > On Fri, Feb 21, 2014 at 5:35 PM, Rupesh Patil > wrote: > >> Hi Expert >> >> I am trying to

$$Excel-Macros$$ Excel micro

2014-02-21 Thread Rupesh Patil
Hi Expert I am trying to get multi select list box value into textbox with comma separated and I am using following code. Private Sub List_Food_Change() Dim item As Integer Dim listitemvalue As String For item = 0 To List_Food.ListCount - 1 If List_Food.Selected(item) = True T

Re: $$Excel-Macros$$ About Create Report

2014-01-10 Thread Rupesh Patil
googlegroups.com] *On Behalf Of *Rupesh Patil > *Sent:* Friday, January 10, 2014 3:19 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ About Create Report > > > > Thanks Ravinder you valuable replay. > > > > is it possible to make well org

Re: $$Excel-Macros$$ About Create Report

2014-01-10 Thread Rupesh Patil
if help > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rupesh Patil > *Sent:* Friday, January 10, 2014 1:49 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ About Create Report > > > &

Re: $$Excel-Macros$$ About Create Report

2014-01-10 Thread Rupesh Patil
PFA On Fri, Jan 10, 2014 at 1:31 PM, Ravinder wrote: > Pls provide some data with example fiel > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rupesh Patil > *Sent:* Thursday, January 09, 2014 11:17 AM > *To:* excel

$$Excel-Macros$$ About Create Report

2014-01-08 Thread Rupesh Patil
Hello Expert I need Micro to generate report on button click. I have excel with 350 column, first column is unique id for each user. each row is record for one user. My requirement is admin person enter id number in text box and hit enter if this id match in sheet in first column then notify to

$$Excel-Macros$$ Run time error '1004' Method "Range " of oblect '_Globle fails

2014-01-02 Thread Rupesh Patil
Hi expert Please look below code and tell me why I am getting this error(Mentions in subject line) Private Sub ComboBox1_Click() Select Case ComboBox1 Case "CAP" pre_Med_Name_1.List = Range("CAP").Value Case "CREAM" pre_Med_Name_1.List = Range("CREAM").Value Case

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

2014-01-01 Thread Rupesh Patil
p).Row > For x = 1 To LastRow + 1 > ComboBox1.AddItem .Cells(x, 1).Value > Next > End With > > End Sub > > > ''rgds. > 'happyNyear > 'Basole > > > > > Em quarta-feira, 1 de janeiro de 2014 06h19min55s

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 t

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

2014-01-01 Thread Rupesh Patil
quot; and i have only one combo box on userform. I hope it is clear now. please tell me if you want more clarification. Thanks again... On Wed, Jan 1, 2014 at 3:36 PM, Bé Trần Văn wrote: > You refer to the Code in File. > > > > 2014/1/1 Rupesh Patil > >> Hi Experts, >&g

$$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

Re: $$Excel-Macros$$ material Stock Inventory in Excel

2013-12-20 Thread Rupesh Patil
x27;t send new queries on others > thread. > > Thanks & Regards, > Sandeep Kumar Chhajer > Mumbai > India > > Sent on my BlackBerry® from Vodafone > -- > *From: * Rupesh Patil > *Sender: * excel-macros@googlegroups.com > *Date: *Fr

$$Excel-Macros$$ Userforms

2013-12-19 Thread Rupesh Patil
Hi expert I need some assistance, dose any buddy have application that used around 10 userForm and save data in excel around 450 columns for one record. thanks in advance -- Thanks and Regards, Rp. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:

Re: $$Excel-Macros$$ material Stock Inventory in Excel

2013-12-19 Thread Rupesh Patil
Hi expert I need some assistance, dose any buddy have application that used around 10 userForm and save data in excel around 450 columns for one record. thanks in advance On Fri, Dec 20, 2013 at 12:59 PM, Jocky Beta wrote: > Hi Sandeep, > > I want an excel sheet form which i can easily gener

Re: $$Excel-Macros$$ About Formula

2013-12-19 Thread Rupesh Patil
ver your range is starting from A2, So > formula should be =vlookup(a2,a2:k494,6,false) > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rupesh Patil > *Sent:* Thursday, December 19, 2013 1:54 PM > *To:* excel-macros@

$$Excel-Macros$$ About Formula

2013-12-19 Thread Rupesh Patil
Hi Experts, =VLOOKUP(K2,A2:K494,6,FALSE) Can any one suggest me, what is wrong with above formula -- Thanks and Regards, Rp. -- 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.co

Re: $$Excel-Macros$$ Top Ten Requestors by Macro or formula.

2013-12-18 Thread Rupesh Patil
Hi Experts, How do I write function that return last row in excel using VBA On Thu, Dec 19, 2013 at 9:43 AM, Prafull Jadhav wrote: > Dear All, > Very good morning and have great day. > > Wating for output. > Regard, > Prafull Jadhav. > 9920553518 > > Dear Prafull, > > > > Let your Macro use the

Re: $$Excel-Macros$$ Update Resords

2013-12-15 Thread Rupesh Patil
PFA On Mon, Dec 16, 2013 at 1:42 AM, ashish koul wrote: > can u share some sample file > > > On Sat, Dec 14, 2013 at 10:23 PM, Rupesh Patil > wrote: > >> Dear Sirs >> How to update record in sheet using userform >> >> -- >> Thanks and Regards

$$Excel-Macros$$ Update Resords

2013-12-14 Thread Rupesh Patil
Dear Sirs How to update record in sheet using userform -- Thanks and Regards, Rp. -- 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,

Re: $$Excel-Macros$$ Date Format conversion

2013-12-03 Thread Rupesh Patil
ate > picker? > > > On Tue, Dec 3, 2013 at 10:46 PM, Rupesh Patil > wrote: > >> since long time i guess no buddy have solution for it >> thanks experts >> >> >> On Wed, Nov 27, 2013 at 9:43 AM, Rupesh Patil > > wrote: >> >>> Hi Exp

Re: $$Excel-Macros$$ Date Format conversion

2013-12-03 Thread Rupesh Patil
since long time i guess no buddy have solution for it thanks experts On Wed, Nov 27, 2013 at 9:43 AM, Rupesh Patil wrote: > Hi Expert > > I need a help for date conversion, let me explain my task, I have one > userform with 10 multipage and each page have at list one date > field

$$Excel-Macros$$ Date Format conversion

2013-11-26 Thread Rupesh Patil
Hi Expert I need a help for date conversion, let me explain my task, I have one userform with 10 multipage and each page have at list one date field(textbox), what i want is user can enter whatever date format he want but i want convert that format "DD-MMM-" so please help me out, How can i do

Re: $$Excel-Macros$$ Email Validation Micro

2013-11-18 Thread Rupesh Patil
Thanks your replay, But I have solve this problem Thanks again On Tue, Nov 19, 2013 at 12:07 AM, ashish koul wrote: > how will u verify what are the conditions > > > On Wed, Nov 13, 2013 at 10:57 AM, Rupesh Patil > wrote: > >> Hi Experts, >> >> I am wr

$$Excel-Macros$$ Email Validation Micro

2013-11-12 Thread Rupesh Patil
Hi Experts, I am writing email validation micro, also i sharing my code with you, can any buddy tell where I am going wrong. I have to call this funtion on text box Exit event code is Public Function isEmailValid(ByVal strEmailAdd As String) As Boolean 'MsgBox ("ok") With CreateObject("VBScr

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-07 Thread Rupesh Patil
Hi Expert. How generate PDF file using VBA. Thanks On Fri, Nov 8, 2013 at 8:10 AM, Basole wrote: > Dear Sanddep, thank you for your kindness! > Sorry, but what is the difference between recordset and querry tables? > > > > > > > Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep

Re: $$Excel-Macros$$ Re: VlookUp VBA : Can't link up with a Text Box

2013-10-30 Thread Rupesh Patil
I have question over here how could userfrom show before without enable micro. Thanks Rupesh On Thu, Oct 31, 2013 at 11:48 AM, TAWHID wrote: > OMG! The Pic become to text !! print screen attached > > > On Wednesday, 30 October 2013 11:42:27 UTC+1, TAWHID wrote: >> >> Can anyone let me know wha

Re: $$Excel-Macros$$ Re: VlookUp VBA : Can't link up with a Text Box

2013-10-30 Thread Rupesh Patil
Dear Tawhid, I have checked this ("When I put an item code in textbox1 it says item not found instead of showing it in the description. ") out and your code is working fine. I have enter item code in textbox1 and got there description in next to the textbox1 label Thanks Rupesh On Thu, Oct 31,

Re: $$Excel-Macros$$ VlookUp VBA : Can't link up with a Text Box

2013-10-30 Thread Rupesh Patil
Dear tawhid I tried your code, I don't any error. thanks Rupesh On Wed, Oct 30, 2013 at 4:12 PM, TAWHID wrote: > Can anyone let me know whats wron in this code below? When I run it says > error in this line: Set lookFor = Me.TextBox1 > > Private Sub TextBox1_Change() > > Dim lookFor As Varian

Re: $$Excel-Macros$$ Validation Micro

2013-10-28 Thread Rupesh Patil
ups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rupesh Patil > *Sent:* Tuesday, October 29, 2013 10:43 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Validation Micro > > ** ** > > Hi exports > > I have sheet with some

$$Excel-Macros$$ Validation Micro

2013-10-28 Thread Rupesh Patil
Hi exports I have sheet with some columns name of the columns is Mis No, Mob No, Student name, email id, others. what i need is take sheet from local system and validate the column such as Mis No and Mob No should be number only, proper email id like that. I have been through some code but not luck

Re: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook

2013-10-28 Thread Rupesh Patil
hi Sagar*.* *First** all of i want's tell, I am new on this forum so excel, so may be this link will help you or you want through it, * http://www.wikihow.com/Consolidate-in-Excel* * * * *thanks * On Mon, Oct 28, 2013 at 12:32 PM, Sagar Kasangottuwar < sagarkasangottu...@gmail.com> wrote: > De

Re: $$Excel-Macros$$ Look up Names from Contacts Sheet & Display Name in an other sheet named call history.

2013-10-28 Thread Rupesh Patil
Thanks Ravinder this formula works for me. Thanks and regards, Rupesh On Mon, Oct 28, 2013 at 12:20 PM, Ravinder wrote: > PFA OR > > ** ** > > =IFERROR(VLOOKUP(A2,CHOOSE({1,2},Contacts!$B$2:$B$13,Contacts!$A$2:$A$13),2,0),"UNKNOWN > NUMBER") > > ** ** > > *From:* excel-macros@googlegro

$$Excel-Macros$$ Re: Introduce Yourself !!

2013-09-20 Thread Rupesh Patil
Hi My name is Rupesh from Pune Maharashtra, India. I am working as technical support engineer and customer support engineer. I am looking for VBA help. actually I have task assigned to build up tool for data entry and I am completely new with VBA so, Thanks and regards, Rp. On Saturday, 9 Jun