Sorry I didn't get back to you earlier.. I had to scrap this approach
as it wasn't going to work in the long run. Requirements changed,
actually, it's a bit of scope creep, but c'est la vie.
On Oct 11, 10:47 am, Paul Schreiner wrote:
> How are you calling thefunction?
>
> I copied yourfunctionto
Sent: Mon, October 11, 2010 9:49:14 AM
> Subject: $$Excel-Macros$$ Custom Function with UserForm
>
> I have a simple function that looks at a single cell for it's value.
> If it's an X, then i'd like for a form to appear. I'd like to pass
> the value rng.ro
I have a simple function that looks at a single cell for it's value.
If it's an X, then i'd like for a form to appear. I'd like to pass
the value rng.row to the form so I can know which row I'm
manipulating. I've failed so far in my attempts to do just that. Any
tips would be awesome.
Function