Userform code

[ramebits]

textbox value not appear in sheetname "BooksStatus" - Suppose I select Hindi from combobox1 (combobox1 list “B2:B14”) and Year 2021-21 from combobox2 (combobox2 List D1, F1, H1, J1 ) want textbox1 vlalue appear in sheetname"BooksStatus" in front of subect select from combobox1 and year select from combobox2.

Combobox1 subjects are English, Hindi, Maths, Sociology whic are are in B2:B14 and combobox2 have 2019-20, 2020-21, 2021-22 etc. are in D1, F1, H1, J1, L1 …...

Suppose I select English form combobox1 and 2021-21 from combobox2, only the value of textbox1 transfer in sheet name "BooksStatus" as per select subject and year from comboboxes


BooksDetailsGSS - Copy.xlsm

 

[RoryA]

Appears to be another duplicate so locked. Please stick to one thread per question.