vba userform listbox

[ccordner]

Is it possible to have a listbox in a userform, where the user selects the data by column instead of by row?

I want to set out a table, based on the days of the week, with days as column headings, so the user can select the day(s) of the week as appropriate.

Thanks
Chris

 

[Sektor]

Is it possible to have a listbox in a userform, where the user selects the data by column instead of by row? ...

Pardon?

 

[ccordner]

Well, I want a userform that is set out like this:

Sun Mon Tue Wed Thu Fri Sat
On 09:00 06:00 06:00 06:00 06:00 06:00 RD
Off
Worked

 

[VoG]

This might help http://support.microsoft.com/kb/q165501/

 

[ccordner]

Sorry, pressed 'Enter' too early.

Sun Mon Tue Wed Thu Fri Sat
On 09:00 06:00 06:00 06:00 06:00 06:00 R D
Off 16:00 13:00 13:00 31:00 13:00 13:00
Worked 08:00 07:00 07:00 07:00 07:00 07:00

I want a table set out in a userform, but so that the user can select one or more columns (days) to then process.

A listbox seems the easiest way to do it, but normally you select a row (on/off/worked), whereas I want them to be able to select a column, or two.

Hope this makes sense.

Thanks
Chris

 

[ccordner]

Thanks for that, but that seems to be about selecting a row and then working on the data for each column in that row.

That table didn't pad out properly, but what I want to do is put up times for each day of the week, then let the user select the columns for the days (e.g. Monday, Wednesday and Thursday) that they want to use.

If it helps, this is to deal with a job-share between two people. The user will need to select which days each person worked each week.

Thanks
Chris

 

[VoG]

I would suggest a Calendar Control http://www.fontstuff.com/vba/vbatut07.htm

 

[Sektor]

In Listbox properties, set:
1. ColumnCount = 7
2. ColumnHeads = True
3. RowSource = Data range EXCLUDING headers (VBA will figure out them) in format "=Sheet1!D15:K22"

 

[ccordner]

The problem with the Calendar Control is it only allows you to select a date. I need to pull information from the roster, which looks a bit like this:

I need to capture the info in the red box and display it in a userform. Ideally, this would be in a listbox so that the user could select Mon, Tues and Wed for Alf and Fri/Sat for Sue.

If I use a Calendar Control, it depends on the user getting the dates right.

I'm not even sure if this is possible, but it would be a fairly foolproof way of doing it you see.

 

[ccordner]

Sorry, picture is here:

http://www.yourfilelink.com/get.php?fid=698573