Posts by iamlost

Quote from royUK

I have tidied up your code by making the ComboBoxes load better.

Check this out, I think it is doing what you need.

I have kept your sheet layout

Roy, You are a hero sir, cant thank you enough (and also Carim) can only hope I can work to having your level of knowledge someday. Thank you again

I didn't even think about a data and time picker , I had "imagined" just typing in a date but you are right not entirely "fool proof"

Didn't understand listing all projects in labels though?

Hello Carim, thanks for the sheet.

If possible I was looking for a user form due to the number of projects and dates there will be as well as to avoid user input error (the task is going from one team to another) therefore trying to make it "fool proof"

Genuinely appreciate all of the help but thinking a userform might be more complicated than I originally thought.

Thank you both.

Carim - Effectively staff will complete paperwork and send to an office which is then input by office staff on a weekly basis. The original template I have covers around 40 different projects and spans an entire year. The intention is to store the data in the spreadsheet and when a new year starts save the last years and create a new template.

Roy - that would be great thank you. I will try and have a look at your website later on tonight.

Ah ok, get the feeling I need to change this. Regarding using a User Form for my problem, do you know if this is possible if I changed to a flat file format?

Quote from Carim

Hello,

You should make your life much much easier and use a flat-file spreadsheet database

See attached

Hope this will help

Display More

Hello,

Please excuse my ignorance, but is a flat file essentially the way the spreadsheet is laid out? Unfortunately I have inherited a template that they would prefer not to change. However if this makes it a lot easier, open to any suggestion.

Thank you again

Hello,

I have an Excel sheet I want to use, where someone can select a Project (Column A = Project1, Project2 ..) a date (Row 1), and a rate of pay (Row 2 = x1, x1.5 and x2)

then enter an amount of hours which will populate the correct cell. There will end of being 000's of projects and span an entire year, hence the reason for an input box. I have tried to use the code enclosed however end up with a few problems.

1. The lists end up with gaps in between them and
2. I can not make the code take the input form data and place it in the correct cell.

I have tried searching google and YouTube but having no luck and my "coding" ability is basic at best

Thank you for any help

[INDENT]Hello All,

I have a spreadsheet that I would like to write code so depending on your USER ID (windows login) will show certain sheet. I know how to get the user id using Environ("username")

so for eg USER 1 - Access to all sheets
USER 2 - Access to sheet 2 only
USER 3 - Access to sheet 3 only.

I have searched various forums / sites but to no avail. I am not even a novice in VBA so if possible treat any answers like your speaking to a 5 year old.

This is as close as I have came but no results or errors.
Private Sub User_Name()

[INDENT]

Private Sub userid()
If Environ("UserName") = "USER2" Then
Worksheets("Sheet1").Visible = xlSheetVeryHidden
Worksheets("Sheet2").Visible = True
Worksheets("Sheet3").Visible = xlSheetVeryHidden


Else
If ("UserName") = "USER2" Then
Worksheets("Sheet1").Visible = xlSheetVeryHidden
Worksheets("Sheet2").Visible = xlSheetVeryHidden
Worksheets("Sheet3").Visible = xlSheetVeryHidden


End If
End If
End Sub

[/INDENT]
Any help pointing me in the right direction would be greatly appreciated.
ps I know this is not 100% secure but will only be used for a small group of people with non-confidential data [/INDENT]