Your problem solved in the attachment. This should help you. Let me know if you still have any query.
On Thu, Dec 18, 2008 at 8:21 PM, xrull <joni....@gmail.com> wrote:
> On Dec 18, 2:52 am, Ajay <ajayvarshney21...@gmail.com> wrote:
> > On Dec 18, 11:08 am, xrull <joni....@gmail.com> wrote:
> >
> >
> >
> > > I need some expert help.
> > > I'm a battering VBA coder (beginner).
> > > How would I make the Sheet Name dynamic for this formula? I need to
> > > type the name of the sheet (Mask or any other name) in a cell, say A1,
> > > and the VBA code below would pick it up and make the necessary
> > > changes:
> >
> > > Private Sub ComboBox1_GotFocus()
> > > Dim listRange As String
> >
> > > listRange = "Masks!A2:" & _
> > > Worksheets("Masks").Range("A2").End(xlDown).Address
> > > ComboBox1.ListFillRange = listRange
> > > End Sub
> >
> > > Thanks
> >
> > Can you explain more what do you exactly want to do
>
> My file has 4 worksheets, and Sheets named Masks, Gloves, Hats, and
> Check has a list in Column A:A, Sheet Check is the sheet with the
> combo box. I'd like to use the cell A1 to type the name of the sheet
> (whether it be sheet Masks, Gloves, or Hat so the name combo box will
> show that list, instead of using 3 combo boxes for each sheet, I'd
> like to use one.
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
Range.xls
Description: MS-Excel spreadsheet
