You can share more information about your selection like if it is range or column or row or multiple sheets. Logic would be same with different types of selection.
objects are workbook, worksheets, range and cells. So, you should check if every object is correct in your line. I doubt in worksheets("sheets1") part it should be worksheets("Sheet1")
thank you. you are a good teacher
This is not working when duplicate values are there. Please how to do that explain. Thanks! @Excel Destination
Good Explained. I like very much.
Sir is it possible find largest 5 values in a column and copy the corresponding 5 rows to another sheet using VBA. if so how?
This is excellent. How does one perform the same for different selections please? Thank you.
You can share more information about your selection like if it is range or column or row or multiple sheets. Logic would be same with different types of selection.
@@ExcelDestination Thank you. I meant if you wanted to use an input box to capture the selection. Thank you though.
you can use inputbox. a = inputbox("enter a number") then use value, stored in a
amazing sir thankx 👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍
Sir, i am getting ' Application -defined or object -defined error ' in set myrange =worksheets("sheets1").range("G4:o20") line. How to fix this error.
objects are workbook, worksheets, range and cells. So, you should check if every object is correct in your line. I doubt in worksheets("sheets1") part it should be worksheets("Sheet1")
@@ExcelDestinationSir , i have corrected to worksheets("sheet1") in the code, still getting the same error.
you can download code for this from www.exceldestination.com
Hi, please provide any example for sort/show the data for top 5. Advanced thanks
I hope to learn how blink in textbox on user form based on condition
For logic, you can take help from following tutorial. Same logic you can use in userform textbox :
ruclips.net/video/rTsKTmBhSKY/видео.html
thanks for a quickly replaying
👍👍👍👍👍👍
sir what about my queries before few days
sorry, which query. can you pls share again.
ya sure sir
about select case statement I want to say that's was result single cells "excellent ""good " "bad" but we want grade result show in range c2:c10
I would suggest you to try for loop statement.
I had try with for loop but cnt complete it there are some usse I know what I cn do but the result nt get so plzz