hay Thanks Daneil......................... On Sat, Jul 9, 2011 at 5:53 PM, Daniel <dcolarde...@free.fr> wrote:
> There is no « TB17 » textbox and that’s why you get an error.**** > > ** ** > > Regards.**** > > Daniel**** > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* samedi 9 juillet 2011 13:01 > *À :* excel-macros@googlegroups.com; dcolarde...@free.fr > > *Objet :* Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in > user from by loop**** > > ** ** > > Please find the attached workbook. on login page use "Mudit Sharma" as > user name and password is nothing.**** > > **** > > On "Credentials Required!" tab i have create a "Test Button" and trying to > fill the counts.**** > > > **** > > On Sat, Jul 9, 2011 at 2:58 PM, Daniel <dcolarde...@free.fr> wrote:**** > > “Me” represents the object containing the code ; so, in this case, « me » > is equivalent to “Userform2”. Can you post your workbook ?**** > > **** > > Daniel**** > > **** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* samedi 9 juillet 2011 00:32 **** > > > *À :* excel-macros@googlegroups.com > *Objet :* Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in > user from by loop**** > > **** > > Daneil, that is what i want.... but the same code is not working.....in my > sheet.**** > > **** > > what is Me.contol ?**** > > **** > > On Fri, Jul 8, 2011 at 10:22 PM, Daniel <dcolarde...@free.fr> wrote:**** > > Give a try at the attached file.**** > > **** > > Daniel**** > > **** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* vendredi 8 juillet 2011 18:17 **** > > > *À :* excel-macros@googlegroups.com > *Objet :* Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in > user from by loop**** > > **** > > Daneil,**** > > **** > > This one "txtbox_val = Me.Controls("TB" & num).Value".**** > > **** > > This is not on the worksheet, i'm using one userform and on which i have > many texboxes...... but i'm not able to put the value in by using loop, once > this is done then i will link it to the sheet values. **** > > **** > > The main fight it how to dynamicly refer TB1,TB2,TB3......TB22**** > > **** > > I really need to do thought loop as many time i have to disable it, enable > it clear the value of the textbox and putting values into the text box..** > ** > > **** > > > **** > > On Fri, Jul 8, 2011 at 6:05 PM, Daniel <dcolarde...@free.fr> wrote:**** > > Didn’t you say the textboxes were in a userform ? if they are on a > worksheet, the syntax should be :**** > > **** > > With ActiveSheet**** > > For i = 1 To 22**** > > txtbox_val = .OLEObjects("TB" & i).Object.Value**** > > Next i**** > > End With**** > > **** > > Daniel**** > > **** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* vendredi 8 juillet 2011 13:11 **** > > > *À :* excel-macros@googlegroups.com**** > > *Objet :* Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in > user from by loop **** > > **** > > Hi Daneil,**** > > **** > > Thanks but it didnt worked..............**** > > **** > > Run-time error '-2147024809**** > > Could not find the specified object**** > > **** > > Thanks,**** > > Shariq**** > > On Fri, Jul 8, 2011 at 11:12 AM, Daniel <dcolarde...@free.fr> wrote:**** > > Hi,**** > > **** > > Try :**** > > **** > > For num = 1 To 22**** > > txtbox_val = Me.Controls("TB" & num).Value**** > > txtbox_num = num**** > > Next num**** > > **** > > Regards.**** > > Daniel**** > > **** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* vendredi 8 juillet 2011 11:00 > *À :* excel-macros@googlegroups.com > *Objet :* $$Excel-Macros$$ Need Help Help Help.....Putting value in user > from by loop**** > > **** > > I’m trying to assign the value in excel user from thought loop.**** > > **** > > Name of the textboxes are TB1,TB2,TB3…….. TB22 .**** > > **** > > Below is the code which I’m using ,but its not working. **** > > **** > > For num = 1 To 22**** > > txtbox_val = "TB" & num & ".value"**** > > txtbox_val = num**** > > End If**** > > Next num**** > > **** > > **** > > The same thing I wanted to do with the label and the names of the label are > L1,L2,L3……L22**** > > **** > > Please help me on this.**** > > **** > > **** > > > > -- > Thanks and Reagrd’s > Shariq**** > > > **** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > > > > -- > Thanks and Reagrd’s > Shariq Shazad Khan > 9999066979,9891184784**** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > > > > -- > Thanks and Reagrd’s > Shariq Shazad Khan > 9999066979,9891184784**** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > > > > -- > Thanks and Reagrd’s > Shariq Shazad Khan > 9999066979,9891184784**** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > > > > -- > Thanks and Reagrd’s > Shariq Shazad Khan > 9999066979,9891184784**** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Thanks and Reagrd’s Shariq Shazad Khan 9999066979,9891184784 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
