Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default I know you can't run a macro while in edit mode, but...

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]


" 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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default I know you can't run a macro while in edit mode, but...

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.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default I know you can't run a macro while in edit mode, but...

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.

" 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.


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default I know you can't run a macro while in edit mode, but...

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.



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default I know you can't run a macro while in edit mode, but...

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.

" 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to stop Tools, Options, Edit sparx Excel Discussion (Misc queries) 0 May 25th 06 10:28 PM
Compiling macro based on cell values simonsmith Excel Discussion (Misc queries) 1 May 16th 06 09:31 PM
How do I edit this macro? Mallers Excel Discussion (Misc queries) 5 April 24th 06 08:32 PM
Highlight Range - wrong macro, please edit. Danny Excel Worksheet Functions 8 October 20th 05 12:11 AM
Running Excel events even in edit mode.... Ishika Excel Discussion (Misc queries) 0 June 16th 05 07:53 PM


All times are GMT +1. The time now is 04:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"