Excel/VBA possibilities

Hello,

I have a question about the possibilities of Excel (in combination with
VBA).
Someone asks me to solve a problem and gives an idea for a possible solution
along with it.
I just want to know if that solution is possible.
Thus I don't ask to solve this problem at this moment, but I only want to
know if it possible in this way.

Namely the following:
One has an Excel-sheet with many columns and rows.

If one starts the .xls-file, a dialog box appears with a couple of fields in
it (easy until now).

By this dialog box, one can choose (e.g. with drop-down menu's or so) which
columns and rows one want to be visible after clicking the OK button. The
idea behind this is that one always needs some columns and rows of a huge
worksheet, but one wants to choose everytime which columns and rows that
are. In this way one can see the desired columns and rows of that huge
worksheet at a glance.
If one is ready with filling in these cells, one clicks on an OK butten
somewhere on the worksheet (e.g. at a taskbar) and the dialog box appears
again to choose another set of columns and rows.

Is this possible or not?

Thanks,
Boudewijn

Yes.

There are probably several ways you could approach it.
You could construct a userform to display a multiselect listbox with the
names of the columns.

It can be shown in the workbook_Open event or again, in a command button.

--
Regards,
Tom Ogilvy


"The Alltime Best" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> I have a question about the possibilities of Excel (in combination with
> VBA).
> Someone asks me to solve a problem and gives an idea for a possible
solution
> along with it.
> I just want to know if that solution is possible.
> Thus I don't ask to solve this problem at this moment, but I only want to
> know if it possible in this way.
>
> Namely the following:
> One has an Excel-sheet with many columns and rows.
>
> If one starts the .xls-file, a dialog box appears with a couple of fields
in
> it (easy until now).
>
> By this dialog box, one can choose (e.g. with drop-down menu's or so)
which
> columns and rows one want to be visible after clicking the OK button. The
> idea behind this is that one always needs some columns and rows of a huge
> worksheet, but one wants to choose everytime which columns and rows that
> are. In this way one can see the desired columns and rows of that huge
> worksheet at a glance.
> If one is ready with filling in these cells, one clicks on an OK butten
> somewhere on the worksheet (e.g. at a taskbar) and the dialog box appears
> again to choose another set of columns and rows.
>
> Is this possible or not?
>
> Thanks,
> Boudewijn
>
>

What you're describing can be done with VBA.

If you only have a handful of visible row/column scenarios to display you
might want to consider using Custom Views. Each named Custom View will
retain its visible row/column conifiguration and print settings. Plus, you
could reconfigure/add/delete a Custom View without having to touch your code.

If the selections will be completely variable, though, then option buttons,
checkboxes, list boxes, etc make more sense.

I hope that helps.

***********
Regards,
Ron

XL2002, WinXP-Pro


"The Alltime Best" wrote:

> Hello,
>
> I have a question about the possibilities of Excel (in combination with
> VBA).
> Someone asks me to solve a problem and gives an idea for a possible solution
> along with it.
> I just want to know if that solution is possible.
> Thus I don't ask to solve this problem at this moment, but I only want to
> know if it possible in this way.
>
> Namely the following:
> One has an Excel-sheet with many columns and rows.
>
> If one starts the .xls-file, a dialog box appears with a couple of fields in
> it (easy until now).
>
> By this dialog box, one can choose (e.g. with drop-down menu's or so) which
> columns and rows one want to be visible after clicking the OK button. The
> idea behind this is that one always needs some columns and rows of a huge
> worksheet, but one wants to choose everytime which columns and rows that
> are. In this way one can see the desired columns and rows of that huge
> worksheet at a glance.
> If one is ready with filling in these cells, one clicks on an OK butten
> somewhere on the worksheet (e.g. at a taskbar) and the dialog box appears
> again to choose another set of columns and rows.
>
> Is this possible or not?
>
> Thanks,
> Boudewijn
>
>
>