Need some more assistance with my roster

[Belleke]

Hi,
I need some more assistance with my roster.
I choose a emplyee
I choose start and end date
I choose status.
On the row of the chosen employee the cells that are equal or between start- and enddate
should get the status value, and the comment should go to the same cells as comment
like .AddComment T_02.Value
Any help is welkom, I am realy stuck

 

[vletm]

Belleke
Why there is an Userform?
Could You do those selections from sheet?
What would include to the comment?

 

[Belleke]

Hi vletm,
Userform because my boss wants it. (All sheets will be hidden, except first sheet)
The comment goes in the textbox "Opmerking" (this is dutch for remark)

 

[vletm]

Belleke
Okay ... the boss knows ...
One variation with the boss style ...
There are short instructions to follow.
... and ... those ActiveX ... who know do those work still?

 

[Belleke]

Hi vletm,
your example is not working.
I get errors
Access error with path or file and 2th error Overflow (translated from Dutch)
You write … without 'form' … this would be more handy …
Can you give me an example what you have in mind.
thanks in advance.

 

[vletm]

Belleke
This 'boss'-version...
1) Open that file
2) Select from 'Rooster 2018'-sheet wanted one employee row range
(= Start-End dates) eg as I've marked with yellow
3) Press [Invulformulier]-button
4) !! You can modify 'Status' and 'Opmerking' !!
5) Press [Invullen] >> and [Sluiten]

Hint: If Your boss would like to have 'endless "Rooster" File and
use same kind of information ( even without form ) ... then ask.
It could eg like below (a sample from other case):
Left top: Status-btns, left 'dates', top names ...
Usage: Select range with mouse (employees*date) and press [Status]-btn.
What else? ... depends need of boss/user.
>> Then no need to do separate eg 'Monthly'-files <<

 

[Belleke]

Sorry vletm,
I followed the instructions, I get errors, I even can't look at the userform object.
I also would like to see the endless "Roster.

 

[vletm]

Belleke
... even cannot .. hmm?
... maybe those Your used ActiveX-somethings?
... here, no challenge

The 'Endless Roster' would look like in that photo .. or as needs.
It have to do just for 'Your case'.
As I wrote, all depends of needs ... and Your boss.

It won't be one hour case to do!

 

[Belleke]

I would like to study the endless roster.
Maybe I can convince my boss this is a beter(faster) solution
Screenshots with the errors
When I push the button I get error 1
When I select cells first an then push the button I get error 2

 

[vletm]

error1.jpg ...
gives image that You have selected cell G14
instead of range as below


error2.jpg ...
I got as below


I can try to make sample of 'roster'...

 

[Belleke]

I can try to make sample of 'roster'...

I appreciate the help.

 

[vletm]

Belleke
Sample of 'Roster' which name is 'Belleke'.
1) Create folder for this
2) Save belleke.xlsb to previous folder
3) Create backup-named folder into previous folder
4) You can open belleke.xlsb

Note:
I took away some parts from original file
means ... some features won't work or would need some modifications!

Usage:
eg Mark 'Annual Leave' for Name1, days 03-Jul-18 ... 05-Jul-18 >>
1) Scroll sheet as You can see those dates
2) Select range G935:G937 = those days and 'Name1'
3) press [ANNUAL]-button (left top corner of sheet)
follow instructions ...
If need to UnMark eg 04-Jul-18 ANNUAL LEAVE,
then select that cell and press [ANNUAL]-button.
(( You won't write straight to sheet! Always with those left top buttons ))

There are more features ...

 

[Belleke]

Thanks for your example.
Have a nice weekend.

 

[vletm]

Belleke
- Userform because my boss wants it.
... so Your bosses still wants that or how?

 

[Belleke]

I didn't have to work further on the project, he went to a IT company to work something out.
Thanks for the interest, have a nice day.