I currently have a VBA form (a worksheet with some text boxes) that lets me easily input requests sent by different colleagues, however one annoying part is that I have to always copy and paste my colleagues' name (which most of them are common "customers").
Therefore, I would like to ask is it possible to write any VBA that could make the text box, by typing the first few letters, it will automatically generate the staff name from a column that consists of thousands of rows (requests sent by hundreds of staffs). Something like: when we type in a cell below some data, the cell will auto-fill with a previously inputted value at the same column.
Therefore, I would like to ask is it possible to write any VBA that could make the text box, by typing the first few letters, it will automatically generate the staff name from a column that consists of thousands of rows (requests sent by hundreds of staffs). Something like: when we type in a cell below some data, the cell will auto-fill with a previously inputted value at the same column.
