Hi Maurizio OK, I think I know what you want. I have done the following: 1) The Listbox will display all the records (in columns) upon initia...
I still don't understand what you want (communication problem again I think). I am only making a guess what you wanted based on your codes. If you ca...
Hi Maurizio I have modified the codes for you. See if this is what you wanted. Sunny
You will also need to change the column count to 12 and add one more column width to show all 12 columns. 'Settaggio di alcune proprietà della List...
Hi Maurizio You are missing a row source. Just include this to UserForm3 in the UserForm_Initialize() code. With Me.ListBox1.RowSource="A2:L56" ...
Hi Khalil See if this is what you are looking for. Note that this is an array formula so you will need to press CTRL+SHIFT+ENTER (instead of ENT...
Just change your formula to =SUMPRODUCT(INDEX(C5:N17,MATCH("Jackie",B5:B17,0),0)) it should give you $307 Hope this helps. Sunny
Hi Julian Add this to your code: 'Play the playlist WindowsMediaPlayer2.settings.setMode "Loop", True WindowsMediaPlayer2.fullScreen = False ...
Hi Christine You can just use a VLOOKUP. Refer example attached. Sunny
Hi Christine I have just answered a similar question for Meshell. See if it will help. Sunny
Hi Paul I am happy to know it is working for you. VBA is definitely the way to go if you want to "conquer the world", as you put it. I am sure M...
Hi Paul Just open both workbook. Press ALT-F11 to display the VBA screen. Drag Module 1 from your current workbook to the new workbook. You can ...
Hi Meshell See if this is what you are looking for. Sunny
Hi Paul You will only need to change the number in red. RowToCompare = 3 'Change this number to the row number you want to compare against. ...
Hi Paul I have written a macro for your specific needs. You will need to change some settings for the macro to run. See the instructions in the ...