Msg error (overflow)

**Mamud** · 09-25-2011, 06:50 AM

hey,

I don't know what's the cause of that error in the below code :

Please Login or Register  to view this content.

The error msg (overflow) in that part:

Please Login or Register  to view this content.

second; I have 16 columns should appear in listBox (lstTable), and i want 2 know If I have a column has a special format in sheet eg. (font:Wingdings 2), How can I format that column in listbox ???

THX...

**Andy Pope** · 09-25-2011, 06:52 AM

How many rows of data do you have?

variable nRow is an integer and can overflow if you have too many rows.

**Mamud** · 09-25-2011, 07:29 AM

hey Andy

I can't determine the no. of rows bcoz the range ot table is renewed and updated

**Andy Pope** · 09-25-2011, 07:32 AM

from the help.

Integer variables are stored as 16-bit (2-byte) numbers ranging in value from -32,768 to 32,767

**Mamud** · 09-25-2011, 07:37 AM

yea Andy, I changed the Integer variable to string, it works

Now, how can I do that

second; I have 16 columns should appear in listBox (lstTable), and i want 2 know If I have a column has a special format in sheet eg. (font:Wingdings 2), How can I format that column in listbox ???

**HSV** · 09-25-2011, 07:54 AM

Originally Posted by Mamud

yea Andy, I changed the Integer variable to string, it works

Please Login or Register  to view this content.

**Mamud** · 09-25-2011, 08:02 AM

hi HSV

I changed it, do u have any answers to my second question?

**HSV** · 09-25-2011, 08:51 AM

Mamud,

Normal:

Please Login or Register  to view this content.

I’ve tried, but for one or two columns in the listbox would not succeed.

Please Login or Register  to view this content.

Sorry.

**Mamud** · 09-25-2011, 09:11 AM

doesn't work

any help

**snb** · 09-25-2011, 10:54 AM

To my knowledge (<E2007) you can format a listbox (like Harry indicated), but you can't format a part of a listbox (row, column, header)

BTW I'd prefer

Please Login or Register  to view this content.

If you omit Option Explicit the VBA compiler will do the dimensioning for you.

Msg error (overflow)

LinkBack

Thread Tools

Rate This Thread

Display

Msg error (overflow)

Re: Msg error (overflow)

Re: Msg error (overflow)

Re: Msg error (overflow)

Re: Msg error (overflow)

Re: Msg error (overflow)

Re: Msg error (overflow)

Re: Msg error (overflow)

Re: Msg error (overflow)

Re: Msg error (overflow)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions