+ Reply to Thread
Results 1 to 8 of 8

Splash screen problem

  1. #1
    Forum Contributor
    Join Date
    08-01-2007
    Posts
    110

    Splash screen problem

    Hi Everyone.

    I am very new to VBA (learning from a book), so that is why I do not understand the problem.

    My problem is as follows:

    I have a splash screen, which loads when I start my workbook.

    On the Sheet1 I have a button command which when started, opens an inputbox. If the name entered in the inputbox equals with one of the given names than the value is displayed in cell D4. If the name is different than the given name than the inputbox reinitializes again.

    My problem is that (however I input the right name in the inputbox) the name is not shown in the sheet1 in cell D4. However if I set it to be shown in sheet2 it shows. The problem seems to be in sheet1.
    The program worked fine till I put in the splash screen, so I am guessing that the splash screen, somehow overwrites, or deletes the data shown in sheet1 D4. Please help me if you can.

    Below you can find the codes.

    Thank you in advance and have a nice weekend!

    Please Login or Register  to view this content.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    What's the point of using the form as a splash screen and a log in. If the button isn't clicked the form should close, allowing access to the workbook, unlessyou build in a procedure to close the workbook if the button is not used.

    I've tidied up your login code
    Please Login or Register  to view this content.
    Hope that helps.

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

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    08-01-2007
    Posts
    110
    Hi Roy!

    Thank you for your help. Actually there is no point of this, but I tried to make it because I am very new to VBA and I am trying to experiment. I use the splash screen as a fancy login screen.

    However still do not know why did the splash screen delete the value of the input box in cell D4.

    In my question I just wanted to know why is that happening, to understand it.

    Thank you anyway!

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    None of your code should Affect d4

  5. #5
    Forum Contributor
    Join Date
    08-01-2007
    Posts
    110
    Hi Roy!

    This is my problem. That it affects it! If you try it with my code, you can see it. And I really do not know why?

    Thank you for your help!

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    You had a typo in the code (" instead of '). using this code the username is put into D3 without any effect on D4

    Please Login or Register  to view this content.

  7. #7
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello hunsnowboarder,

    I created a workbook using your code and could not reproduce the problem either. The only thing was a typo in the InputBox that Roy pointed out. Once that was corrected, the workbook opened correctly and placed the name into cell D3. The data I placed in D4 remained intact. It remains a mystery.

    Sincerely,
    Leith Ross

  8. #8
    Forum Contributor
    Join Date
    08-01-2007
    Posts
    110
    Hi! Thank you all for your help! I really do not find the typo... Anyhow now it works! Thank you a lot!

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1