Re: $$Excel-Macros$$ Custom Function with UserForm

2010-10-19 Thread RemyMaza
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

Re: $$Excel-Macros$$ Custom Function with UserForm

2010-10-11 Thread Paul Schreiner
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

$$Excel-Macros$$ Custom Function with UserForm

2010-10-11 Thread RemyMaza
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