Hello. I've inherited these timesheets that have combo-boxes in them for
drop-down menus (to categorize expenses). I need to update the lists in the
combo boxes, and I'm not sure how to do this-- I'm not familiar with visual
basic.

This is what I see when I open the code in Visual Basic.

Private Sub ComboBox1_Change()

End Sub

Private Sub ComboBox1_MouseDown(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Single)

End Sub

Private Sub ComboBox20_Change()

End Sub

Private Sub ComboBox7_Change()

End Sub

Not sure how to find the text to change. Thanks for any help!
Christine

There's nothing in those procedures. They're just stubs waiting for code to be
added.

If these are comboboxes from the control toolbox toolbar that are placed on a
worksheet, then show that control toolbox toolbar.

Select one of the comboboxes.
rightclick on it and choose properties
look for listfillrange

This may be the thing you need to adjust. Actually, that would point to a range
on some worksheet where you'd add/delete/modify the values. Then you adjust
that .listfillrange property to point at the adjusted range.

Christine wrote:
>
> Hello. I've inherited these timesheets that have combo-boxes in them for
> drop-down menus (to categorize expenses). I need to update the lists in the
> combo boxes, and I'm not sure how to do this-- I'm not familiar with visual
> basic.
>
> This is what I see when I open the code in Visual Basic.
>
> Private Sub ComboBox1_Change()
>
> End Sub
>
> Private Sub ComboBox1_MouseDown(ByVal Button As Integer, ByVal Shift As
> Integer, ByVal X As Single, ByVal Y As Single)
>
> End Sub
>
> Private Sub ComboBox20_Change()
>
> End Sub
>
> Private Sub ComboBox7_Change()
>
> End Sub
>
> Not sure how to find the text to change. Thanks for any help!
> Christine

--

Dave Peterson

That worked-- thank you!!

"Dave Peterson" wrote:

> There's nothing in those procedures. They're just stubs waiting for code to be
> added.
>
> If these are comboboxes from the control toolbox toolbar that are placed on a
> worksheet, then show that control toolbox toolbar.
>
> Select one of the comboboxes.
> rightclick on it and choose properties
> look for listfillrange
>
> This may be the thing you need to adjust. Actually, that would point to a range
> on some worksheet where you'd add/delete/modify the values. Then you adjust
> that .listfillrange property to point at the adjusted range.
>
> Christine wrote:
> >
> > Hello. I've inherited these timesheets that have combo-boxes in them for
> > drop-down menus (to categorize expenses). I need to update the lists in the
> > combo boxes, and I'm not sure how to do this-- I'm not familiar with visual
> > basic.
> >
> > This is what I see when I open the code in Visual Basic.
> >
> > Private Sub ComboBox1_Change()
> >
> > End Sub
> >
> > Private Sub ComboBox1_MouseDown(ByVal Button As Integer, ByVal Shift As
> > Integer, ByVal X As Single, ByVal Y As Single)
> >
> > End Sub
> >
> > Private Sub ComboBox20_Change()
> >
> > End Sub
> >
> > Private Sub ComboBox7_Change()
> >
> > End Sub
> >
> > Not sure how to find the text to change. Thanks for any help!
> > Christine
>
> --
>
> Dave Peterson
>