+ Reply to Thread
Results 1 to 3 of 3

Write to Spreadsheet with Userform/Message Box On

  1. 05-25-2009, 05:06 AM #1
    arora
    arora is offline
    Registered User
    Join Date
    08-08-2008
    Location
    Dresden
    Posts
    68

    Write to Spreadsheet with Userform/Message Box On

    Hello all,

    I have a question related to Userform and/or Message box. In case a macro solve and displays the result as in Userform and Message box then is it possible to write (type) the values to the excel sheet without closing the Userform or Message box ?

    Thank you in advance
    kanwar arora
    Last edited by arora; 05-25-2009 at 06:23 AM.
    Reply With QuoteRegister To Reply
  2. 05-25-2009, 05:10 AM #2
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Write to Spreadsheet with Userform/Message Box On

    You can show a UserForm as modeless, enabling you to work with the sheet. Change the forms ShowModal property to false.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
  3. 05-25-2009, 06:23 AM #3
    arora
    arora is offline
    Registered User
    Join Date
    08-08-2008
    Location
    Dresden
    Posts
    68

    Re: Write to Spreadsheet with Userform/Message Box On

    Hello Roy,

    Thank you very much, I was unaware of the location of this property but now found it in the properties section and it works .

    Thanks again,
    Kanwar arora
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1