PDA

View Full Version : Sleeper: What screen resolution do you run Excel in



brettdj
10-10-2004, 09:38 PM
I've received a couple of messages stating that my userforms in an addin are too big in 800x600 resolution........ I run my screen at 1280*1024 and that has been the basis of my design

So I'm curious - is there a "default" resolution out there?:dunno

Cheers

Dave

Jacob Hilderbrand
10-10-2004, 10:11 PM
I use 1024*768. 1280*1024 gets too small to be confortable for me. I think if you design for 1024*768 it will look ok on the other resolutions. Or you can make three UserForms, one for each resolution you want to support. :)

TonyJollans
10-11-2004, 12:42 AM
I use 1280*1024.

I would expect the membership of this forum, and possibly users of your addin, to use higher resolution than the general public.

One advantage I find of using the higher resolution is that you can have more than one visible window - everything doesn't have to be maximized. In this case also, you don't want userforms to be too big.

As a side note, I find a lot of apps (though not Excel) really don't make good use of screen real estate beyond what fits comfortably on 1024*768 (or even 800*600) - how many web pages do you see that are fixed width, for example?

Glaswegian
10-11-2004, 01:51 AM
1024 x 768 at work - mainly because we don't have great equipment here (surprise! surprise!) but at home I use 1152 x 800 (something - can't remember!). But that's partly because I have a decent monitor. Even with my eyesight I can read everything quite clearly!

Haven't experienced a problem with user forms but did have one business unit complain that they had to scroll about a great deal to view a spreadsheet I had created - turned out they all had their monitors set at 800 x 600 and view setting at 125% - aaaaaaarrrggghhhhhhhhhhhh!!

mvidas
10-11-2004, 05:32 AM
I use 1024x768 both at work and at home, and while looking around at my workplace it seems 1024x768 is the standard around here. Going along the lines of DRJ's idea of multiple userforms, you can get the current resolution using the code found here (http://www.vbaexpress.com/forum/showpost.php?p=8737&postcount=2). I'm sure you've used it before, but I figured the reminder couldn't hurt.
Matt

Ken Puls
10-11-2004, 08:39 AM
Hi,

I use 1152*864 at home (as I don't want to make my wife blind), but at work I use the best I can get out of my monitor. I voted 1280*1024, but I think it might be slightly higher. I'll check on Tuesday.

For reference, our web designers tell me that they design all web sites for 800*600, as that is the industry standard for monitors at this time.

Cheers,

Zack Barresse
10-11-2004, 08:56 AM
1024 x 768

:)

And w/ that even everybody tells me it's too small, although I like it. :yes

XL-Dennis
10-11-2004, 09:30 AM
Dave,

The default standard seems still be 800x600 while most user have large crt-screens or flat-screen and therefore run 1024 x 768 mode.

I?m running in Windows 1280 x 1024 and one mainreason is to have several windows open at the same time. Wasn't that the main-purpose with MS Windows? As for Linux I usually use 1024 x 768 and I would propably get a resolution-shock if I was forced to use 800 x600 :D

lucas
10-11-2004, 09:36 AM
Dave,

I also run 1024*768 at home but many of the computers I encounter at work are still running 800*600. I travel a lot and am often given a plant issue computer to work off of. I have to take this into consideration when designing my spreadsheets.

mdmackillop
10-11-2004, 10:11 AM
1152 x 864, but too young to vote :bink:
MD

Juan Pablo Gonz?lez
10-11-2004, 01:24 PM
1280, but I always design with 800x600 in mind... even 640 x 480 !!

XL-Dennis
10-11-2004, 01:29 PM
Hi CM Juan,



even 640 x 480 !!

I?m curious about the conditions when You must consider this resolution ;)

KR,
Dennis

sskappel
10-11-2004, 01:31 PM
I use 1280x1024. I also feel this is the standard since it is the res. of 17", 18" and 19" lcd's.

One consideration is of course laptop screens. Mine is 1024x768. But I know it's a small screen, and would not complain about sites not adjusted for it's resolution.

ss

Juan Pablo Gonz?lez
10-11-2004, 01:35 PM
Hi CM Juan,


I?m curious about the conditions when You must consider this resolution ;)

KR,
Dennis
Clients with *very* old computers, and VERY reluctanct to upgrade.... and/or with eyesight problems.... in other words, they like to see everything *big* !

Mark O'Brien
10-11-2004, 02:29 PM
I voted 1024. I believe it depends on two or three things:

1. Quality of the monitor (In work, I have a 4 y/o Dell Trinitron)
2. Age/eyesight of the user
3. Size of the monitor (1024 works good in 17", but I believe 1280 works better in 19")

I've always worked under the assumption that most people have 17" monitors set at 1024, mainly because that is the most common size and setting I see. Then again, I don't design applications or spreadsheets for other people. If they've got a problem with my work, tough poops. :p

johnske
10-11-2004, 04:23 PM
Because i) I'm old and my eyesight is not the best ii) have a small monitor and iii) an older PC I use 800*600.

Mosta my frendz ('ordinary' users) also use the same resolution, so I know that whatever I do for them should appear the same on their PCs.

Perhaps the wider use of higher resolutions shown above explains why I very often cannot access the worksheet tabs on lots of the zipped files I have downloaded from VBAX (even after closing all toolbars) :bink:

Zack Barresse
10-11-2004, 04:33 PM
Mark: :rofl

CBrine
10-13-2004, 06:49 AM
I use the 1280*1024. This tends to make some of the windows text pretty small, so I also go in and change the font size's on my windows controls to compensate for this. Results=Lots of room to see and play in excel and other programs, and also readability for the windows text.

Tommy
10-13-2004, 09:07 AM
I use 1600x1200 on a 19".
I also find that the resolution is half of the problem. Some users have the large text option (the ones that need reading glasses and don't want to wear them) set. This means if the resolution is accounted for the text in the labels will wrap etc.
The users I have to deal with use from 640x480 with 16 colors to 1600x1200 with true color, from 14" to 21". So the end result is I design my forms on a 800x600 with 16 color.

EricFletcher
10-13-2004, 09:44 AM
1024x768... but with 2 monitors and UltraMon to allow occasional use across both screens for 2048x768 -- useful for web log analysis. I just got a new laptop with 1280x800 and the extra width is very handy.

Jacob Hilderbrand
10-16-2004, 01:57 AM
Here are some numbers for this site (for October):

1024x768 = 60%
1280x1024 = 15%
800x600 = 13%
1152x864 = 8%
1600x1200 = 2%
Others = 2%

WillR
10-22-2004, 01:26 AM
I'm in the 60% at work & the 15% at home...

Again mainly due to equipment quality :)

Shrout1
10-22-2004, 06:32 AM
I use 1600x1200 on a 19".
Same here - My work screen is a 17" and I just cannot get the real-estate I need without shrinking it down to insanely small sizes.

When you're working with VBA you usually have 3 things always active on the screen - Your userform, your excel file and VBA code window while you step through and debug.

I've talked to my boss about getting a dual monitor setup, but since this is just a "side job" for me, no such luck.

EricFletcher
10-22-2004, 07:52 AM
Same here - My work screen is a 17" and I just cannot get the real-estate I need without shrinking it down to insanely small sizes.

When you're working with VBA you usually have 3 things always active on the screen - Your userform, your excel file and VBA code window while you step through and debug.

I've talked to my boss about getting a dual monitor setup, but since this is just a "side job" for me, no such luck.

If you can find an old unused monitor kicking about (they seem to be everywhere in 2nd hand places around here now -- and for as little as $5!) and almost any video card (also very cheap), you can probably add a 2nd monitor on your own. Even better, add one to your boss' system and he'll never argue against it! I like mine so much I'm going to add a third.

50gumbys
10-24-2004, 10:05 PM
1024x768 are the company settings.

It's the same at home as well.

And I have to admit - I like big writing!!
(oi - leave my glasses alone!! )