I know you can't run a macro while in edit mode, but...

I'm wondering if you can interact with a form while a macro is running?
Also, if a macro is inputting data into a sheet is that considered
edit mode? I'm trying to figure out a way around this if @ all
possible.

Can you explain a little more about what you're trying to do or test? Since,
by definition when you're in break/edit mode the code has stopped executing
the answer is very close to no.

But by judicious use of breakpoints or the Stop command you can set places
in the code to examine/alter data, then continue on to the next point using
[F5] or step through your code line by line using [F8]


"[email protected]" wrote:

> I'm wondering if you can interact with a form while a macro is running?
> Also, if a macro is inputting data into a sheet is that considered
> edit mode? I'm trying to figure out a way around this if @ all
> possible.
>
>

I've been brainstorming on how I want to work a webservice. What I was
thinking is maybe I could link some labels and buttons in a form to
cells or maybe just send the data straight to the form. However if
there is a request/response being processed I would like to have the
ability to use the buttons on the form.

I don't think you want to be running a web service out of Excel. It will
probably need a database tied to something like FrontPage to develop the web
based interface for forms.

"[email protected]" wrote:

> I've been brainstorming on how I want to work a webservice. What I was
> thinking is maybe I could link some labels and buttons in a form to
> cells or maybe just send the data straight to the form. However if
> there is a request/response being processed I would like to have the
> ability to use the buttons on the form.
>
>

Sorry I meant user end. I'm not sure what to do. I'd rather not mess
with .net as I really don't like dealing with datagrids and DT's and
stuff. Excel is easier.

I'm afraid I'm going to have to bow out on this one. I don't have enough
experience trying to put interactive Excel application up in a network
environment to do you any good at all. For that kind of thing I either:
#1 - let one my webmasters do it.
#2 - create a web form on a page to display/accept information from the end
user and pull inputs into a database, then back at my end, use Excel to grab
what it needs from the database and do what needs to be done with it in
Excel. I probably shouldn't say this here too loudly, but I usually use
PHP and connect with an Access db on my personal site, then manage the db
data transfer via other primitive methods (as FTP). But my needs in that
area is very meager.

Sorry I can't be of more assistance to you.

"[email protected]" wrote:

> Sorry I meant user end. I'm not sure what to do. I'd rather not mess
> with .net as I really don't like dealing with datagrids and DT's and
> stuff. Excel is easier.
>
>