vba

Hi - I have an excel table with 6 Columns (fixed) and then I want to be able to fill in as much content in the rows without limitation. Problem: I want the table contents to fill into the charts and automatically and automate adjust, so that it’s easy to read with the same excel sheet if...

Dear All, I have a workbook with many sheets with multiple slicers in each sheet. I am looking for a vba code that is assigned to a button, on clicking it it should hide all the slicers and again clicking it it should unhide. The button text should change based on slicers current status...

Hello! Is it possible to have a formula or code that allows for selecting multiple selections from a drop down list that can appear in one cell? Potentially separated by commas? I've seen some folks talk about a VBA code, or a potential list box, but I am not sure where to begin. Attached is my...

Good morning, I searched the web for an answer, tested few but without success. Please move this to the correct forum if needed. I have a PowerPoint with several slides, each with one or more pictures linked to saved png files. They were added using this path: Insert Tab / Pictures / This...

Hi everyone, I'm an excel newbie and trying to figure out how to make something work in VBA. Y'all seem like a really nice bunch, so I'm hoping you can help me out! I've managed to automatically create a pivot table containing days worked per week per person from a raw data file and would like...

Dear all, I am a new user of Excel VBA and try to use it to automize the daily working routine. Now I'm facing the problem of checking duplication and change the value. So basically what I would like to do is to check the order for customers and I would like to check whether there are...

Hello! I have a workbook that lists products we sell, for who, when and how many we have sold of each product. I would like to add macro into workbook, which based on multiple criterias can figurate the exact matching and return the requested relevant information, what I need. To simplify my...

Hi there, I have a VBA that works perfectly fine for its current use, however I need it to be more specific about where it pastes the data. I really need a code that takes the value in a selected cell, copies it to the next empty cell in the column between rows 4-8, adds cell colour fill...

Hi all, I'm copying some data over from an input spreadsheet into a data table, I'm using the below code which finds the first blank cell in the tables first column and correctly updates the value, but then when I repeat it moves down a row, I assume because the table auto creates the whole...

Hello All I created this code. evrithing seems fine but ALL THE TIME error 5 Sub Exportar_Imagenes() Dim img As Shape, tempChart As ChartObject Dim sPath As String, sName As String Dim imgEncontrada As Boolean ' Ruta donde se guardarán las imágenes sPath =...

Hi! i´ve been struggling with this one for a bit now. I want to paste something into the Last Column Header of a Table. I´ve tried with following code: ActiveSheet.ListObjects("TableName").HeaderRowRange(LastColumn).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone...

I'm not really sure what you'd call what I'm trying to do, but here's my best attempt to describe it. I'm creating a summary sheet that will pull from an unknown number of sheets. I've employed Indirect to assist me as I hate #REF errors should referenced sheets get deleted. I have my macro...

Hi out there, my project is about creating userforms based on the values in a worksheet. People planning their USFs in advance or work with templates can accelerate the setup in a smart way. The code to create this both items is: ' the objects are declared as VBComponent Set mdl =...

Hi all, Silly question but this is so unintuitive for me: For Each Table in Doc.tables For Cnt=1 to Table.Rows.Count Row = Table.Rows(Cnt) If ... DataRow = Table.Rows(Cnt+1) MsgBox DataRow.Cells(2) End If Next Cnt Next Table I can do...

dear all, I'm currently stuck with Excel and I hope you guys can help me. I am looking to lock specific rows (in the screenshot: the forecast quantity) D6-O6, D9-O9, D12-O12, D15-O15, etc (until D24-O24) after a specific date has passed. This date will be defined in D3-O6. So the way it...

Private Sub Game_Num_Val_Change() Dim cntl As Control Me.Game_Num_Val = UCase(Me.Game_Num_Val) Set cntl = Me.Game_Num_Val Call VerticalAlignCenter(cntl) End Sub Public Sub VerticalAlignCenter(ByRef ctl As Control) MsgBox 1 On Error GoTo ErrorCode Dim MinimumMargin As Integer Dim...

Hello Experts, I am in need of a VBA script for doing mentioned task: 1.Searching multiple occurence of same keyword from the text file 2.Copy keyword line till end of the line of each occurence and paste in different worksheets for different occurences 3.Performs the "Text to Columns" operation...

I currently have the issue I cannot backspace on the first value in a cell without throwing all other values in the cell off. This seems to happen when the cell only has 2 values - a Stop Alert I’ve called ‘User Error’ (using Data Validation) is not thrown either. I’m trying to standardize...

Hi, I have some values in column A which just contain an 'x'. Then I have some values in column C that just contain a 'y'. I want to have some vba code that will filter all rows that have an 'x' in A OR a 'y' in C. Is it possible? James

Hey everyone! I am currently trying to implement a function into a workbook that has many worksheets. Each worksheet has individual dates stored in cells E1:R1. When the workbook is opened I want the code to immediately run (so I put it in the Workbook_Open sub). The code looks through each...