yes, follow the directions to create a button, but this time the Visual Basic code for this "backtrack" button becomes (assuming that the spreadsheet index is like in the video found in the BL2 cell): i = Range("BL2").Value Range("BL2").Value = i - 1
@@LajeunesseLab Possible to have another guidance video from you demonstrating semi-automatic population of 'exclusion reasons' when a citation is excluded (as it's imperative for most of the SLR's to provide reasoning for exclusion of citation). Thanks in advance.
This video is absotely helpful! I would like to ask if it is possible to add a colour, for ex. green for "included" and red for "excluded" studies, because in that way i think it can facilitate the identification process.
@@LajeunesseLab Thank you very much for your response was very helpful! But when i change this settings that you referred to when i press the button of the inclusion does not display at the screen cell "include" in green colour.
@@xriso1437 Oh I see, in my first comment I thought you meant changing the button colors. Yes you can also change the color of the "INCLUDE" or "EXCLUDE" decisions by adding this additional line to the VB button code outlined in the video (below will change the color of "INCLUDE" to blue; you can modify to vbRed for the "EXCLUDE" button): Private Sub CommandButton1_click() i = Range("BL2").Value Range("BG" & i + 1).Value = "INCLUDE" Range("BG" & i + 1).Font.Color = vbBlue Range("BL2").Value = i + 1 End Sub
@@LajeunesseLab Possible to have another guidance video from you demonstrating semi-automatic population of' exclusion reasons' when a citation is excluded (as it's imperative for most of the SLR's to provide reasoning for exclusion of citation). Thanks in advance.
I am planning to do these types of videos, in the mean time I have a course where I conduct an entire meta-analysis from start to end: ruclips.net/p/PLMDcoG6cxhI0JRfmuv3AwT9Sy0FQNMqCL
Is there a way to add a back button for if reviewers make mistakes?
yes, follow the directions to create a button, but this time the Visual Basic code for this "backtrack" button becomes (assuming that the spreadsheet index is like in the video found in the BL2 cell):
i = Range("BL2").Value
Range("BL2").Value = i - 1
Hi all, thanks for watching!
I have more tutorials using Excel for meta-analysis and systematic review practices, the full list is found here:
@t
I am unable to find it, can you help me?? Thank you.
Hi from Belgium! Very helpfull, thanks for sharing !
Thank you so much sir 😊
I wish I had Excel skills so i understand the functions you used and so apply your method..But, I will try to copy your steps right now!
thank you so much ! very helpful !
Glad it helped!
Excellent sir, really learned a lot
Super helpful, thanks!
Glad it was helpful!
@@LajeunesseLab Possible to have another guidance video from you demonstrating semi-automatic population of 'exclusion reasons' when a citation is excluded (as it's imperative for most of the SLR's to provide reasoning for exclusion of citation). Thanks in advance.
thank you!
This video is absotely helpful! I would like to ask if it is possible to add a colour, for ex. green for "included" and red for "excluded" studies, because in that way i think it can facilitate the identification process.
yes you can, do a right click on the button and go to 'preferences'. There you can modify the color of the button or text color
@@LajeunesseLab Thank you very much for your response was very helpful! But when i change this settings that you referred to when i press the button of the inclusion does not display at the screen cell "include" in green colour.
@@xriso1437 Oh I see, in my first comment I thought you meant changing the button colors.
Yes you can also change the color of the "INCLUDE" or "EXCLUDE" decisions by adding this additional line to the VB button code outlined in the video (below will change the color of "INCLUDE" to blue; you can modify to vbRed for the "EXCLUDE" button):
Private Sub CommandButton1_click()
i = Range("BL2").Value
Range("BG" & i + 1).Value = "INCLUDE"
Range("BG" & i + 1).Font.Color = vbBlue
Range("BL2").Value = i + 1
End Sub
Thank you very much. That works perfectly.
@@LajeunesseLab Possible to have another guidance video from you demonstrating semi-automatic population of' exclusion reasons' when a citation is excluded (as it's imperative for most of the SLR's to provide reasoning for exclusion of citation). Thanks in advance.
Do you have a template? Thanks for the uploads!
Great video, but i couldn't get it working on my MAC, there was no control section on developer
Dear can you please share any video where i have to know the basics before starting a meta analysis?
I am planning to do these types of videos, in the mean time I have a course where I conduct an entire meta-analysis from start to end:
ruclips.net/p/PLMDcoG6cxhI0JRfmuv3AwT9Sy0FQNMqCL