As the attachment is a rota, sheet1 can be ignored, see the data of sheet2,

Appeal:
1, when open the workbook, it can automatic popup who is on duty today,
2, click on the query. I am on duty today, after input the name, you will be prompted on duty today whether

The existing way of thinking:
1, open the worksheet, use today determine date and agree A column of A row, and then use the msgbox popup corresponding row B column values, similar vlookup, VBA don't know how to implement, however,
After 2, click on the first define a variable, and the Inputbox assignment, the assignment after the query name and date of corresponding today are equal, such as equal popup today is my duty, if not equal pop-up today is not my duty,

Ideas are currently, learned helplessness of VBA, don't know how to get the cell's value, also please help to see, thank you very much,

CodePudding user response:

Msgbox activeworkbook. Sheets (" Sheet2 ") cells (1, 1). The value

Cells said two parameters, starting from 1, 1,