where on earth is the macro?
 

I have a strange problem. A spreadsheet includes a combo box and a macro has
been associated with the combo box and so I know the name of the macro. But I
can't find the macro nor dissociate the macro from the box. In looking for
the macro, I have clicked on "View Source" from the tab name, switched to VBE
and checked the visible objects, but no joy. Can someone tell me where to
look for this mysterious macro please? thanks.... Greg

where on earth is the macro?
 

Perhaps it is a combo from the forms toolbar.

Select the combo, right click and select Assign macro if there is one. The
macro would then be in a standard code module.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"gvm" wrote in message
...
I have a strange problem. A spreadsheet includes a combo box and a macro
has
been associated with the combo box and so I know the name of the macro.
But I
can't find the macro nor dissociate the macro from the box. In looking for
the macro, I have clicked on "View Source" from the tab name, switched to
VBE
and checked the visible objects, but no joy. Can someone tell me where to
look for this mysterious macro please? thanks.... Greg

where on earth is the macro?
 

Thanks Bob for the reply,
yes it is a combo box from the forms toolbar

the problem I am having is that the value in the cell link becomes something
different from the value I select from the dropdown list. When I looked at
the combo box properties, it appeared to have a macro associated to it and
hence I assumed the macro was causing the value in the link cell to be
changed. I now think the assumption was wrong.

Why might the real cause of my problem be please?

where on earth is the macro?
 

Are you getting a number in the link cell not the value? If so, that is the
index of the item selected not the item itself.

You need to look it up. Suppose your list range is A1:A100, the link cell is
b1, then in C1 add

=MATCH(B1,$A$1:$A$100,0)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"gvm" wrote in message
...
Thanks Bob for the reply,
yes it is a combo box from the forms toolbar

the problem I am having is that the value in the cell link becomes
something
different from the value I select from the dropdown list. When I looked at
the combo box properties, it appeared to have a macro associated to it and
hence I assumed the macro was causing the value in the link cell to be
changed. I now think the assumption was wrong.

Why might the real cause of my problem be please?

where on earth is the macro?
 

Bob, you have described my problem and your suggested solution does work,
thank you. What causes the index value instead of the lookup value to be
inserted to the link cell? The dropdown list is not intended to work that way
is it? Thanks again..... Greg

where on earth is the macro?
 

It is designed to work that way. Oddly, the combo from the controls toolbar
works differently, the linked cell shows the selected value.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"gvm" wrote in message
...
Bob, you have described my problem and your suggested solution does work,
thank you. What causes the index value instead of the lookup value to be
inserted to the link cell? The dropdown list is not intended to work that
way
is it? Thanks again..... Greg