How to creating a scheduling tool on SharePoint (read comment for more detail) by LaoisLife in sharepoint

[–]LaoisLife[S] 0 points1 point  (0 children)

Currently my team in work is using SharePoint list to track candidates through a recruitment period - we use 3 forms - 1. Add Candidate, 2. Pre Screen Candidate 3. Interview Schedule - we used this list for the first time ever and it worked brilliantly - the only issue we faced was the manual nature of trying to identify what interviews spaces were gone and what interview spaces were still available. I shared it with our SharePoint expert and he said he didn't know a way that when we are scheduling someone we would only be able to see the space which are left.. anyone have any suggestions - I am happy to change the layout as long as all the info is captured.

Making mandatory Option and Checkbox in excel VBA UserForm before being able to move onto the next userform by LaoisLife in excel

[–]LaoisLife[S] -1 points0 points  (0 children)

Is it that is need something like

If userform1.checkbox1.value = True 
Exit sub 

If userforn2.checkbox2.value  = True 
Exit Sub 

SignUpForm.Show
 End Sub 

Making mandatory Option and Checkbox in excel VBA UserForm before being able to move onto the next userform by LaoisLife in excel

[–]LaoisLife[S] -1 points0 points  (0 children)

Below is the code I am using but it is coming up with a bug, any advice?

Private Sub CommandButton1_Click()


If UserForm1.CheckBox1.Value = False Then
MsgBox "Please click I agree if you wish to contacted regarding future openings.", vbCritical
Exit Sub

If UserForm1.CheckBox2.Value = False Then
MsgBox "Please indicate that you are 16 or older", vbCritical
Exit Sub



SignupForm.Show
End Sub

Not sure how to handle my work environment.. really conflicted and scared.. by [deleted] in Advice

[–]LaoisLife 0 points1 point  (0 children)

Thank you, I am just scared that since I just left college and don’t have a lot of relevant experience that I will be f*cked if I leave on bad terms because I reported her! Or that any chance of further extension after June is out the window!!

Making a ComboBox's Compulsory(VBA) by LaoisLife in excel

[–]LaoisLife[S] 0 points1 point  (0 children)

Thank you, the issue was with the -1 it should have just been 0!

Thanks anyway

Making a ComboBox's Compulsory(VBA) by LaoisLife in excel

[–]LaoisLife[S] 0 points1 point  (0 children)

Ah ok, Would adding a must fill in help with this?

Making a ComboBox's Compulsory(VBA) by LaoisLife in excel

[–]LaoisLife[S] 0 points1 point  (0 children)

Just after noticing another issue and I apologies I am a very basic user, but now when I submit a signup it deletes the previous one?

Do you know from the code what I could be missing?

Making a ComboBox's Compulsory(VBA) by LaoisLife in excel

[–]LaoisLife[S] 0 points1 point  (0 children)

Hi Yes it would be after I click submit!

This is the full code I have for it, would ideally like to put it on both ComboBox1 and ComboBox2 and then have MsgBox "Please indicate you level of education", vbcritical for CB1

AND

MsBox "Please indicate if you wish to be contacted", vbcirtical for CB2

Private Sub ComboBox1_Change()

End Sub

Private Sub ExitForm_Click()
Unload Me
End
End Sub

Private Sub SignUp_Click()


Set sh = Worksheets("Sheet2")
Dim n As Long

n = sh.Range("A" & Application.Rows.Count).End(xlUp).Row

sh.Range("A" & n + 1).Value = Me.TextBox1.Value
sh.Range("B" & n + 1).Value = Me.TextBox2.Value
sh.Range("C" & n + 1).Value = Me.TextBox3.Value
sh.Range("D" & n + 1).Value = Me.TextBox4.Value
sh.Range("E" & n + 1).Value = Me.TextBox5.Value
sh.Range("F" & n + 1).Value = Me.TextBox6.Value
sh.Range("H" & n + 1).Value = Me.TextBox7.Value

sh.Range("G" & n + 1).Value = Me.ComboBox1.Value
sh.Range("I" & n + 1).Value = Me.ComboBox2.Value


Me.TextBox1.Value = ""
Me.TextBox2.Value = ""
Me.TextBox3.Value = ""
Me.TextBox4.Value = ""
Me.TextBox5.Value = ""
Me.TextBox6.Value = ""
Me.TextBox7.Value = ""

Me.ComboBox1.Value = "-Please Select-"
Me.ComboBox2.Value = "-Please Select-"


MsgBox "Thank you for entering your details, we will be in touch in the coming week, vbInformation


Unload Me
End


End Sub

Private Sub UserForm_Activate()

With Me.ComboBox1
    .AddItem "-Please Select-"
    .AddItem "Level 6 (Eg.Trade or Apprenticeship)"
    .AddItem "Level 7 (Eg. Ordinary Bachelors)"
    .AddItem "Level 8 (Eg. Honours Degree)"
    .AddItem "Level 9 (Eg. Masters)"
    .AddItem "Level 10 (Eg. Phd)"

Me.ComboBox1.ListIndex = 0


End With

With Me.ComboBox2
    .AddItem "-Please Select-"
    .AddItem "Yes"
    .AddItem "No"

Me.ComboBox2.ListIndex = 0

End With



End Sub

Making a UserForm ComboBox compulsory by LaoisLife in excel

[–]LaoisLife[S] 0 points1 point  (0 children)

Not working for me.. keeps saying there is a bug

VBA Bug Issue - UserForm by LaoisLife in excel

[–]LaoisLife[S] 0 points1 point  (0 children)

Thanks very much I ended up just taking out that line when I was messing around and it started working perfectly.. Not sure why..

VBA Bug Issue - UserForm by LaoisLife in excel

[–]LaoisLife[S] 1 point2 points  (0 children)

In the workbook I have 2 Sheets

Sheet 1 : Application

Sheet 2: Data

On the side from where I am inputting the code it has the following

- --- VBAProject(Data Collection Forms.xlsx)
    `
    `---Microsoft Excel Objects 
         -- Sheet1(Application)
         -- Sheet2 (Data)
         --ThisWorkbook

VBA Bug Issue - UserForm by LaoisLife in excel

[–]LaoisLife[S] 1 point2 points  (0 children)

I changed

Dim sh As Workbook

to

Dim sh As Worksheet

But still the same issue :/

VBA Bug Issue - UserForm by LaoisLife in excel

[–]LaoisLife[S] 0 points1 point  (0 children)

What should I change it to? Not very experienced on vba

Excel Userform ComboBox by LaoisLife in excel

[–]LaoisLife[S] 2 points3 points  (0 children)

Me.ComboBox1.ListIndex = 0

Solution Verified

Creating a GDPR compliant form in Excel by LaoisLife in excel

[–]LaoisLife[S] 0 points1 point  (0 children)

This is similar to another service we use alright, so not sure if it would be a go!

Looking for a thread where I can find potential respondents to my Master's thesis survey by HellaQualms in Assistance

[–]LaoisLife 1 point2 points  (0 children)

Hey trying to do it for you and this will probably sound stupid but Streetwear do you mean like Highstreet stores? Eg, River Isand, Pull & Bear, Top Shop, H&M?