Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

2011-07-09 Thread shariq khan
el-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 > > ** ** > &

RE: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

2011-07-09 Thread Daniel
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, 2

RE: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

2011-07-09 Thread Daniel
-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 wrote: Give a try at the attached

Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

2011-07-08 Thread shariq khan
ps.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 > > ** ** > > Dan

Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

2011-07-08 Thread shariq khan
> > ** ** > > 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$$

RE: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

2011-07-08 Thread Daniel
o: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 '

RE: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

2011-07-08 Thread Daniel
Which line gets the error ? 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

Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

2011-07-08 Thread shariq khan
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 wrote: > Hi, > > ** ** > > Try : > > ** ** > > For num = 1 To 22 > > txtbox_val = Me.Controls("TB" & num).

RE: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

2011-07-08 Thread Rajan_Verma
You have to make a loop through each OleObject Embaded on Worksheet, See if it helps. Sub LoopWsCntrl() Dim OLECont As OLEObject Dim lRow As Long, lCol As Long For Each OLECont In Sheet1.OLEObjects If OLECont.progID = "Forms.TextBox.1" Then Variable = OLECont.Object.Val

RE: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

2011-07-08 Thread Daniel
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@go