Hei. I am just facing one issue with this tutorial that is not matching mine. The cursor does not select the sheet inside the list box. Only when I go out of the listbox boundary and click something else outside, does the selection update. Why is that?
Hi Leila, is it possible to use a multi select enabled list box to "insert" criteria for sumproduct ? ... ie I want to use sumproduct to do a sum based on OR criteria logic and point to the listbox selection ?
Regarding your little "hack" at the end. You could have made the code in a module and had sheet_activate run the module sub, then in workbook_open link to the same module sub. That way you don't force the user to a different sheet, and you can open the workbook on print sheet and it will be updated
Can we use RowSource property....for specific range....but for different sheets.......for example we use ListBox1.RowSource = "Sheet1!D21:F30" ... In the above code instead of Sheet 1 if we use ComboBox1.value.......then it doesn't work if ComboBox1.value is sheet name.......any suggestions..**no one answered me till date** I just wanted data to show in listbox with fix range"B61:G75" from different sheet i.e after changing combobox which contains sheets name.....pls help....if you can do this...
HI Leila Gharani... I really appreciate on your effort to make this video. It's teach me a lot of new thing to do in excel. Really thanks for it. HErewith I have a query that I would like to get your assitant on it... I would like to create in excel sheet the population of my neighborhood by create the command box or tex box the number of house. When ever we click the textbox or command box with the number of house, the detail of the owner of the house can be display either in print preview or in tabulation. CAn you assist me on it. I have to solve it, but unable to get it... appreciate your assitant on it. Thank you...
I have excel file which contain 100 invoice number. Now I want to search those invoices from a folder which contain 2000 files. Now I want to search 100 invoice and print at one ago. It's is possible with VBA.
My list box keeps changing sizes after I close the worksheet, It will then sometimes cover my print preview option. Any suggestions to lock size and location of list box?
Hi Leila! I want to do this, but for several specific print areas within the same sheet. I can’t figure out how to do this. I created defined names for the different print areas and put them in an activex list box, but i’m not sure how to write the VBA code for it or what to do next.
hi maam Leila Gharani, nice video tutorial... and please do a tutorial on how to create a bold function in excel, on how to bold a specific text in a string formula... thanks in advance.
Very cool But it does not work well when I hide the tabs and changes in the sheet formatting. When the tabs appear, it works well. I don’t know what the problem is. I don’t want to show the tabs
I have a table with student info, then I want to print student card base one student info in the table, however, is there a way to just want click then can print all student card.
Leila, I would like to embed an insurance rates calculator on my website so customers can can check their insurance quotes. How can I do that or can I use your services in the respect? Thanks.
Hi Leila. I must say that you're my heroine 😁. I applied step by step the way to print many workseets at the sametime but I have an issue. Do hou have a webside where I could expose my problem? Thanks, François Montréal, Quebec(Canada)
It would probably be best if you would post it on Microsoft's Tech Community Platform for Excel: techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral
Hello Genius, We need help.. We are manufacturing company, we created cartoon box stickers in #excel sheet, but we are facing one problems we are added box numbers also, we want to print box numbers continously when we are taking print continue box numbers also examples we take 100 stickers starting 1to 100 box numbers to print continuesly Can any one know how to do this in Excel using #macro or #VBA #manufacturing COMMENTS
Why do you not use integer for i? By the way I got so much value from this video, I didn't know about the Locals window, Break, icons for macros, now I know byte is 0-254 and only takes up 1 byte instead of 2 for integers, I learned to populate listboxes and the difference between selections allowed, WOW. Thank you!
I need to print quite a few excel file to PDF with specific file name format. Examplefor file name is Invoice number_PO number_serial NUNBER Please help how to do it.
Greetings to you, Miss Truth. You have a wonderful and distinctive method of explanation and in a smooth language. I have Excel sheets for printing via Listbox, but after printing there is always a problem with the rest of the codes, so how can I send you the file. Sorry for the poor expression, it's just a translation
Leila, as I remember, it is impossible to print out, if more then one sheet is selected in the workbook which is protected. Also UserInferfaceOnly doesn`t help in this case. VBA return an error. If you could give me a hint ...
Hi. I want to print a searchable drop down list from a worksheet. My drop down list is in worksheet "Form 138" and is found in cell "R15." Can you please help me how to do this?
Regarding printing: I got a table that fits in a single page when printed. The table has titles in the top row. When choosing a value from the top left filter in the top row of the table, the dependent array below the filter gets filtered accordingly, and so the whole table now has less rows than when it's unfiltered. What's the VBA code to automatically select the first value from the filter, and automatically print on paper the filtered table; then select the second value from the filter, and automatically print on paper the filtered table; and so forth until you have finished printing on paper all available values from the filter? Thanks in advance.
hello, maybe you can help me, i have made a worksheet with a dropdown list there are 2 the second has to be dependent on the first, then there is the hard to believe that it has to be looked up in three other worksheets (S1, S2, S3) they are all the same in content, what do I want to do now, in cell E2 I can enter numbers from 1 to 3, if I do I want to look up the names, in the second list I want to look up the names the ones below, can you help me?
Very helpful video. How can I add another button which would print (or select) all sheets? Just as a shortcut if I would print them all more often. Without loosing preview function.
Hi Leila, I have been following your channel for a while now and I would really appreciate if you could help me with printing in landscape as well as portrait within the same worksheet. I could print one-one page but it would take a lot of time especially if I have to print the same document again and again. So how will you approach this problem? I would love to hear your thoughts. Thanks.
This has been very helpful. I'm stumped on how to do this same thing, but automate print/saving to PDF. Specially using ExportAsFixedFormat. Any suggestions?
Great tutorial! I did it and it worked while testing. However now it does not work properly for a "random"selection. Keeps saying "error 1004". Any ideas of what I'm doing wrong?
This is great! How would you filter that list in the list box based on certain cells on each sheet having data? (automatic instead of manual selection?)
Hi Leila.. thanks.. great video and useful tip and tool to add to any workbook for easier previewing and printing. I can think of many parallel uses, such as a choice to save selected sheets to PDF or save selected sheets as a separate workbook, etc. Always a pleasure to view your videos and practice learning your techniques and implementing your ideas in my own work product. Thumbs up!
Thanks Leila.. glad to be part of the process. I built your code into a workbook with some hidden sheets and realized the need to trap for that and not load them to the list box, otherwise the PrintPreview or PrintOut routine fails, if a hidden sheet is selected for processing from the list. I added this code.. problem solved. For Each ws In Worksheets If ws.Visible = xlSheetVisible Then Me.ListBoxSh.AddItem ws.Name End If Next ws Before following your channel and taking your VBA course, I wouldn't have known where to begin, let alone being able to solve the problem for myself. Thanks for all your help and inspiration. Looking forward to your next video. Thumbs up! PS - Also added this code to trap for attempting to print with nothing selected in list box.. the fun never ends with VBA.. haha!! If c = 0 Then MsgBox "Nothing was selected.. try again!" Else Sheets(SheetArray()).PrintPreview End If
Hi Leila, thanks for sharing the knowledge and helping others. I used this type of code to make a child activity record where teachers can enter the child activity per session. All is inputted from a central sheet which I would like to keep visible but not listed with in the list box is that possible please.
Thank you very much for this trick and one more thing mam how to view vba code if Excel is locked by unviewable project shared workbook ...how to crack it ...looking for your reply
Wonderful tutorial!! I am still very new to this, is there a way to have your list box to show only certain tabs? Looking to not show my first two tabs but to show the rest. Thank you!
This Tutorial was Impressive and I am in Learning stage. I wonder Is it possible to print in single page, different sections of same sheet. for example: In sheet1 I want to print cells A1: B5 and C10:F20 . Just in my mind. Thank you.
Hey there! I've been learning a lot from your videos! I'm putting together a whole template for a project at work. This ALLLMMOOOST does what I need it to, and I'm not sure how to get it there. I'm hoping to select all visible sheets (this is variable), except one called "Instructions," and print them out as one print job, so that the pages are numbered properly. As my code stands right now, it prints each sheet in the workbook as a separate print job, and numbers them based on how many pages are on the given sheet, rather than the whole. Private Sub PrintAll_Click() Dim Wks As Worksheet For Each Wks In ActiveWorkbook.Worksheets If Wks.Visible = xlSheetVisible Then If LCase(Wks.Name) "Instructions" Then Wks.PrintOut End If End If Next Wks End Sub Thank you for any help you can provide!
I usually use dictionary instead of arrays due to how... Ehmm.. poorly VBA handles arrays. Too much problems with resizing and not being associative. Dictionary's can expand and be associative and is, to me, easier to use.
Hey Leila, thank you for your great videos!! Could you make a video on how to extract data from text?? I will explain myself a little more: if I get the text "Dear Jauri, could you fill in the forms AB11001, AB11002 and 11003", I would like to copy the whole text and paste it in one excel cell. As I result I would like a list: "11001" in cell A1, "11002" in cell A2 and "11003" in cell A3. Note that the form number starts with either "AB11" or "11". I Would appreciate it! thank you ^^
Crude but... paste text into A1, Make A3 this: =SUBSTITUTE(SUBSTITUTE(UPPER(A1)," AB11"," ~11")," 11"," ~11"), then make A4 this: =MID($A3,FIND("~",$A3)+1,5), then paste this into B4:B10: =IF(A4"",IFERROR(MID($A3,FIND("~",$A3,FIND(A4,$A3))+1,5),""),"")
Thanks a lot for your amazing way in explanation these topics. I have a list with some items that are dynamically connected to the sheet it’s located on and want to print that sheet for each item in the list, is it possible to do that using macro?
Thank you so much for your help on this topic and the many others you have shared. I will definitely be using this code in an upcoming project. One thing that I would add is a message box to alert the user if they have not chosen a sheet and then hit the Preview button. When one runs the macro an error message pops up. I added the following and it did the trick. Thanks If c > 0 Then Sheets(SheetArray()).PrintPreview 'If you'd like to print out ' Sheets(SheetArray()).PrintOut Else MsgBox "No Sheets have been selected" End If
Not Only This but all of your tutorials are awesome ! Your way of Explaining is great and You are Best Online Instrutor for me ever. Wish You Good Luck !
Leila, I think I'm in love with you. My goodness you make Excel and VBA for that matter, so damn beautiful. In all seriousness, appreciate the sharing of knowledge, have learnt a ton. ✌🏾
Wow! what a great teacher. You are wonderful. I have just started a course which requires me all these things that you're teaching and it has been so resourceful to me. Thank you