Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to fake/simulate more than 256 columns
Greetings,
I'm using an Excel spreadsheet to define and maintain a data-set used by another application. So, the spreadsheet is a "UI" where users' control over sheet is limited. The data represents a "daily schedule" where the user contols how many days are defined. The right-most column represents the last day defined by the schedule. It's reasonable to expect a schedule will (need to) define more than 256 days (columns). I'm considering maintaining a data-set on another sheet, or in a disk-file, and just populate the UI according to what user wants to see. For instance, maybe up to 60 columns are used, and when the user wants to see a 61st day, the data is programmatically "scrolled" to the left such that column 60 holds day 61, and column 1 holds day 2. Of course it would be nice to employ the standard worksheet scroll-bars, but if I have to manage one, so be it. If anybody [is not completely confused by now, and] has tried anything like this, or if you have any enlightening ideas, I'd be interested in hearing from you. Thanks/Cheers! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simulate Check Box | Excel Discussion (Misc queries) | |||
simulate mouse movement | Excel Programming | |||
simulate down arrow | Excel Programming | |||
Macro to Simulate F2 | Excel Programming | |||
Simulate Click Event | Excel Programming |