Results 1 to 8 of 8

Form takes a long time to open

Threaded View

  1. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,524

    Re: Adding a drop down Calendar to VB User Form

    Your one named range is 65536 rows long.

    Use this to populate the Line Lead ComboBox
    '-------------------------------------------
        Dim LstRw1 As Long, r As Range
        LstRw1 = ws.Cells(Rows.Count, "A").End(xlUp).Row
        Set r = Range(ws.Cells(1, 2), ws.Cells(LstRw1, 1))
        cboName.List = r.Value
    '-----------------------------------------------
    Right click on the Tool Box,select add additional controls, see if You can find Microsoft Date and Time Picker. Click it to add to your tool box.
    Last edited by davesexcel; 11-27-2010 at 03:03 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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