created

Hi, I have a number of workbooks, named by date they were created, and need a summary of how many rows each workbook has. Thanks Jon

I have created a Userform programmatically and created a series of controls on the form. Now I want to read from/write to one of the text boxes. I have tried everything that I can think of to reference to the control, but I'm having no luck. The control was originally created as part of the...

Would it be possible to have your help to create a macro that allows to send an email notification based on the assigned name on ComboBox3 where I can modify the subject and automatically attached a pdf file that it is previously created. The path of the pdf file changes depending on the entry...

I have a vba which creates a new worksheets whose name is dependant on a cell value. At the same time it also created a PDF file of the same sheet. What I want it to do is also protect the newly created worksheet only. I have tried a few things to no avail. This is what I have so far Sub...

Hi All~ I have a user that occasionally experiences this error -- "Update or CancelUpdate without AddNew or Edit" The db I administer has about 20+ end users, split db, front end accde files on each users's desktop. This error occurs (only occasionally) when he is creating a new entry into...

I have a graph that I need to recreate from a vendor. Only I don't know how they created the arrow that grows with the size of the value. Take a look at the linked image, any ideas? https://drive.google.com/open?id=1OJd86ejvZRjV4c_j2AZE5XFuGhNgDVhZ

As the title states, I haven't dealt with the worksheetfunction alot and I've never dealt with it when it came to a function that I created. So I am not sure why my function doesn't show up but it shows up on the spreadsheet. Any help would be greatly appreciated. Thank You

Hi all, I have created a macro which reads column B and then creates separate sheets based on the values-text found on that Column. I obviously get an error while new sheets are created. The 1st one is when text is over 31 characters. This is resolved. The 2nd one is when i have the 7 sin...

Hello all, first time here! I'm not proeficient much with VBA, hopefully someone can help me. I need a VBA script to create a dynamic amount of sheets at once based on 12 different cells value, from 3 different template sheets (I need to keep those 3 templates formula intact) and based on some...

Hi all I'm about to have a genuine emotional breakdown over a spreadsheet I've created for work and I'm really hoping someone can help me work out wth is going on and how to fix issues I'm having please. In short, I work at a training company and have created a spreadsheet with multiple...

I created simple macros that do the same thing. A text is typed when clicking on a button that runs my macro. I created then a macro to delete the texts that I typed. The texts generated by my macros appear in cells different to those I originally chose when creating my macro. My Excel...

Hey everyone, I've got a few problems I'm having using vlookups - I feel like there's gotta be something I'm not thinking of. - Is it possible to get a lookup to find the Nth instance of a lookup value? - Can I easily add together every instance? Maybe this is a case for Match instead...

Hey all, I am cracking my head without finding a logical solution for this problem. This is a small picture of my database (on the left) and I created a pivot table (on the right) to summarize this information. I would like excel to get the lowest number from the column G (date) and insert it...

Hi Everyone, hope you can help I need a formula or macro to add new sales to existing sales invoices. we have clients that p[lace orders and pay over 16 instalmentsand offten add new items to the first order When we get and order an invioce schedule is created with dates and amounts due...

I'm trying to reference a filename and path that I've created with a formula. I can't get it to work either in a formula or with a Macro.

Hello, I have a very limited knowledge of Access and am struggling through and enjoying creating my first database. When in query design view, I created a field by entering the following formula into the field region: Lab$: [LabHours]*([CrewRate]+[OHRate]) So when I switch to datasheet view...

Hi. I have created a new ribbon using the editor and have created about 60 new tabs. Well as you imagine having all these tabs are a bit of nightmare scrolling along to find the tab i want. Does anyone know if there is a way of using a macro to search for a particular tab, maybe a combobox...

Hi, I've been reading other posts here similar to my issue but I can't seem to get some of the workarounds or methods used to work. We had an intern working with us over the summer and he created a bunch of different reports in Power BI, I still have access to his account but my company needs...

Hi all, Below is the code to create a new workbook with the active worksheet of an open workbook Sub sb_Copy_Save_ActiveSheet_As_Workbook() Set wb = Workbooks.Add ThisWorkbook.Activate ActiveSheet.Copy Before:=wb.Sheets(1) wb.Activate wb.SaveAs...

Hi all, Imagine I have a combobox from a userform that allows me to navigate through a workbook with many sheets -dozens of dozens- I would like to know why the code of the userform initialize does not add the name of the sheet to the combobox when a new one is created Current code...