Saejosmlqfy

 I'm trying to populate a two column combo box I am using in a user form taking the data from a Table The combo list needs to be dynamic so when additional items are added to the Table they are fed into the combination box I'm using a before event double click to initiate the code but the form is not initialising My table's name is Table1, as you can see here in the name box Now, if you've ever tried to reference an Excel Table as your Data Validation lists source like this "The formula you typed contains and error" Method 1 Use the INDIRECT function with the tables structured references like this Method 2 Give your Table another name inName Box In Excel, the Name Box refers to an input box directly to the left of the formula bar The Name Box normally displays the address of the "active cell" on the worksheet You can also use the name box to quickly create a named range Another use for the Name Box is to navigate quickly to any range in a worksheet I...

The first, middle, and last name are Here is an easy way to insert the current worksheet's name into a cell Insert the following formula into any cell and press enter =MID (CELL ("filename",A1),FIND ("",CELL ("filename",A1))1,255) In the below we have called the worksheet Sales Data The formula above is in cell A1 This could be used as a handy way to insert I use Excel a lot, not just for crunching numbers, but for creating teaching resources, lesson planning, managing my accounts and invoices and various other uses One feature that I often use, is the ability to have the sheet name appearing inside a cell in the spreadsheet so for example with my invoices Insert Sheet Name In Cell Easy 3 Methods To Return The Worksheet Name Excel insert sheet name in cell