Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Selecting Range after splash screen

  1. #11
    New Member
    Join Date
    May 2002
    Location
    Baltimore
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    yea, I tried Jay's. I didn't feel like changing all that. So I just format the column? I was thinking too complicated I guess. Thinking of formatting the actual value before it is entered in the cell.

  2. #12
    New Member
    Join Date
    May 2002
    Location
    Baltimore
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What happens if I get so many orders that its more than the amount of cells I formatted nate?

  3. #13
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ??

    I think you just formatted the entire column, at least the way I described it, you did. So, if you're approaching 65,535 orders, you may want to clear this sheet (that's a lot of Pizza).

    Should we write an event procedure just to be sure?

    Code:
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Application.Intersect(Target, [a65536:d65536]) _
    Is Nothing Then [2:2].Delete
    End Sub
    Right click on the 2nd sheet, and paste the following code. Since you're only doing 1 pizza at a time, if you fill the section, it will delete your oldest order, row 2, and allow you to continue adding new orders.

    Hope this helps.

  4. #14
    Board Regular
    Join Date
    Apr 2002
    Location
    Nashua NH
    Posts
    164
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm trying to establish my splash screen but with little result concerning color, font, etc. I have been trying to create one by trial and error but I know for sure there is an easier way. What is the easiest way to create a splash screen?

  5. #15
    New Member
    Join Date
    May 2002
    Location
    Baltimore
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Create your workbook as usual.

    Activate the Visual Basic Editor and insert a new UserForm into the project. The code here assumes this form is named UserForm1.

    Place any controls you like on UserForm1. For example, you may want to insert an Image control that has your company's logo. Also, you may want to set the UserForm's Caption property to an empty string.

    Insert the following subroutine into the code module for the ThisWorkbook object:

    Private Sub Workbook_Open()
    UserForm1.Show
    End Sub
    Insert the following subroutine into the code module for UserForm1:
    Private Sub UserForm_Activate()
    Application.OnTime Now + TimeValue("00:00:05"), "KillTheForm"
    End Sub
    Insert the following subroutine into a normal VBA module:
    Private Sub KillTheForm()
    Unload UserForm1
    End Sub

  6. #16
    Board Regular
    Join Date
    Apr 2002
    Location
    Nashua NH
    Posts
    164
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've created a userform to show at start up, a splash screen if you will. But is there a way to kill that blue border and X so it doesn't show? I have found a way to kill the X here on the board. How about that top border? Anyone?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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