Hi! I need to validate if a number in a cell in excel is between 1 and 10. How would you write that? I tried using an if statement saying something like (if *** 10) then. And then a msgbox asking for the user to type something between 1 and 10 but it doesn't seem to work.
The link to this tutorial will guide: www.exceltrainingvideos.com/data-validation/ IF Function in Excel: www.exceltrainingvideos.com/if-function-2/ Simple IF: =IF(AND(C1>=1,C1
@@Exceltrainingvideos Thank you for the answer. I need to do it only in VBA, and when i type what you wrote, it won't work :/ The worksheets work that way, that an infectionspecialist has to write an assessment of a patient between 1 and 10, and I have to make VBA validate, if the value written is between 1 and 10.
This VBA tutorial link should help: www.exceltrainingvideos.com/automate-date-validation-using-vba/ Search www.exceltrainingvideos.com or this channel also.
Will you show me how to calculate 1Name 2Item 3bags 4weight 5rate 6unit 7total This is the second time my question ? Previous also I asked you didn't answer me.
These links will help: www.exceltrainingvideos.com/inventory-management-in-excel/ www.exceltrainingvideos.com/inventory-management-using-sumif-function/ Or search www.exceltrainingvideos.com
Good to see you back in action sir
Sir very Excellent video.
Good and informative video.
Hi Sir, I would like to showcase dates in the email body according to the calendar to send weekend reminders mail. Could you give me any suggestions?
Uncle, I need help.
I want to make date bettwen 01/08/23 - 31/12/23.
How? Please help me
muy excelente video
Hi!
I need to validate if a number in a cell in excel is between 1 and 10. How would you write that? I tried using an if statement saying something like (if *** 10) then.
And then a msgbox asking for the user to type something between 1 and 10 but it doesn't seem to work.
The link to this tutorial will guide: www.exceltrainingvideos.com/data-validation/
IF Function in Excel: www.exceltrainingvideos.com/if-function-2/
Simple IF:
=IF(AND(C1>=1,C1
@@Exceltrainingvideos Thank you for the answer. I need to do it only in VBA, and when i type what you wrote, it won't work :/
The worksheets work that way, that an infectionspecialist has to write an assessment of a patient between 1 and 10, and I have to make VBA validate, if the value written is between 1 and 10.
Hi sir,If i want to validate date & time in particular format,how i have to change the code
This VBA tutorial link should help: www.exceltrainingvideos.com/automate-date-validation-using-vba/
Search www.exceltrainingvideos.com or this channel also.
Nice one sir...
Is it possible to type date in VBA (userform textbox or combobox) in dd/mm/yy format and same to transfer to excel sheet
Should be possible. Try it out!
Will you show me how to calculate
1Name 2Item 3bags 4weight 5rate 6unit 7total
This is the second time my question ?
Previous also I asked you didn't answer me.
These links will help:
www.exceltrainingvideos.com/inventory-management-in-excel/
www.exceltrainingvideos.com/inventory-management-using-sumif-function/
Or search www.exceltrainingvideos.com
Isdate is not full proof if you enter 33 jan it will take it as valid date.
Did you try to run my macro with that value? What was the result?