Hi again guys and gals
*
I’m currently still making alterations to a decent sized workbook with plenty of VBA within its bowels
*
It’s pretty much done however I have spotted something that could be utilized better by adding a simple combo box and possibly some referencing code to fill another cell with an individuals phone number…..
*
The workbook essential generates a weeks worth of work for the department and then allows for rostering etc..
*
There is a Sheet called Temp which is the template for each item of work within the workbook… I believe this sheet “Temp” is filled copied and the copy then renamed before the original “Temp” sheet is then cleared, then the process happens again.
*
Cell Range C26:C125 are available for staff names input and Cells D26:D125 for the staff contact number… I have previously added a combo box for staff names however these don’t copy over to the newly generated sheets All With “PP*” prefixes…
A simple dropdown list works ok and copies to the newly generated PP* sheets but the font size is a pile pants !!!
*
What I would like to know is if there is any way that I could make the font size larger in the drop down box without auto zooming and more importantly if I select a name from the List “Staff1” and I auto import the phone number from the adjacent cell into the new worksheet ce which again is adjacent to the name ???
*
This would be a real time saver!!!
*
Any help and advice as always is truly appreciated
*
Thanks in advance
*
James