Results 1 to 30 of 30

userForm -> Frame 'top' value limited. Dynamically created controls,

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2013
    Location
    Katowice
    MS-Off Ver
    Office 2007
    Posts
    19

    userForm -> Frame 'top' value limited. Dynamically created controls,

    Hello,
    I'm working with MS Office 2007.
    I have an Access database with client's data. I'd like to show those data on Excel's user form in the frames generated dynamically - one frame for one client (frame caption value is sth like: 'Client number ' & guyNumber). On one frame there will be all of the data shown with dynamically generated labels and textboxes. All of those frames are placed inside the main frame (e.g. name: 'ListOfClients').
    Every client's frame has its height: 40. The frames are stored one under other. Scroll bar size of the main frame is also calculated dynamically, depending on numbers of client's.

    Until now it's easy.

    Now the problem is with placing all of those client's frames inside this main frame. As I mentioned, every frame is 40 px high so I calculated, that next frame's 'top' value will be: "guyNumber * 40" and it worked until I run it with the bigger database. I noticed that for number of clients bigger than ~820, excel shows: runtime error '6' - overflow.

    I couldn't find out where's the problem but I finally did: The calculated 'top' value is bigger than 32767 (Microsoft reccomends this value to be an integer not bigger than 32767, which is max for integer value). But I need more.
    Is there any solution or workaround to have those data correctly shown without any errors?

    I'll be glad for any solution.

    Best regards,
    Michal
    Last edited by kropeck; 08-18-2013 at 05:34 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using Class Module for handling events of dynamically created controls
    By jagman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-17-2018, 01:14 PM
  2. Add MouseMove action to dynamically created form controls
    By AdLoki in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 03-19-2013, 09:09 AM
  3. Creating UserForm Controls dynamically
    By MWE in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2005, 12:05 AM
  4. [SOLVED] Creating Userform Controls on Frame
    By David Myle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2005, 11:06 AM

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