Re: Combo Box - HELP

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If you want continue to use =mround(), then you'll have to have that analysis
toolpak installed.

ynissel wrote:
>
> Im not sure of their version but it seems to be an issue.
> The other issue I have is that I used the MRound function in the file and
> since its an ADDIN in the analysis tool pack many users of my file get errors
> ! Is there a way around this without making them install the add-in ?
> Thanks,
> Yosef
>
> "Dave Peterson" wrote:
>
> > What version of excel are they using.
> >
> > If they're using xl97 or later, then this isn't the problem.
> >
> > ynissel wrote:
> > >
> > > I send this file to other users who dont necessarily have the same version
> > > excell as I do - and this is causing an error message to appear. Can this be
> > > overcome ?
> > > Thanks.
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > That combobox's value is text.
> > > >
> > > > Maybe you could use a helper cell that points at the linked cell:
> > > > =--a1/100
> > > > Formatted nicely.
> > > >
> > > > ynissel wrote:
> > > > >
> > > > > I have a combo box that I formatted 0.000% and it works great. But the cell
> > > > > its linked to - which is also formatted as % to 3 decimal places wont format
> > > > > as a % - and thats a displayed cell so I need it to format properly.
> > > > >
> > > > > any ideas ??
> > > > >
> > > > > Thanks,
> > > > > Yosef
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson
.

Quantcast