LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Listbox Height Question

I found the problem. The "IntegralHeight" was set to True!! For some
reason, the height cannot be changed "right away". It wants to show full
rows, so that's why it was changing the height from 50 down to 49.2. Then it
would let VBA change it until a MsgBox statement was issued or some other
code! (I still don't know why and under what conditions it would change.)

But after changing the IntegralHeight to False, then I could change it just
fine. I should say that it wasn't being changed!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Row Height question Eagle Excel Discussion (Misc queries) 3 December 2nd 08 08:31 PM
Cell Height question [email protected] Excel Discussion (Misc queries) 3 November 5th 07 05:26 PM
Row Height Question Dave Excel Discussion (Misc queries) 0 February 7th 07 02:06 AM
Row Height Question Dave Excel Discussion (Misc queries) 2 February 6th 07 01:36 AM
Wanted func to determine height of ListBox row count Excel Programming 2 May 24th 04 06:38 PM


All times are GMT +1. The time now is 03:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"