excel

Hi, I'm hoping you can help. I'm trying to automatically add some values of a Bill of Materials. I have numbers in column A which represent the level in the Bill of Materials, column B is the price, column C is where to totals should go. The criteria is that if the next row is greater than the...

Hello, I am currently working on with a user form which has multipage tool, and each page has different tools such textboxes, combo boxes and checkboxes. This user form will be use as a data entry tool which will be populated into specific columns once the user click submit. Whenever I try to...

I'm stumped on this one - I'm currently automating a file and I need the macro to select the most recent date slicer dynamically. My current code is selecting all of the dates listed in the slicer instead of the most recent date. Sub maxdateslicer() Sheets("FIP").Select...

Hi I am trying to do a sumproduct as a dynamic vba code but I cannot get it to work. I'd use XL2BB but i'm on a work computer so i can't install anything, so attaching picture for some clarity. This is for an order form and the reason i want it dynamic is because the number of rows changes...

I have looked at a lot of different ways to do this and tried to incorporate their ideas into this sub but I keep getting different errors every time I run it. I am searching for "0" in the listed ranges of the STATUS SHEET and finding the offset value which is the vehicle number. then finding...

Hi VBA Developers, Hope you are fine, Please note I have been trying to create a database but in this case, I only need a column with the data, based on some parameters but during the process I am confused since the code I think should have some loops. Probably my code is a mess, but...

I have about 30+ hidden sheets. Normally on clicking unhide, a dialogue box opens. And suppose there are 8 sheets with sheet name starting with letter "C". To unhide specific sheet, I would continue typing "C" and then selection would move to hidden sheets with name starting with "C". I would...

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 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...

I want to sumifs based on weeks of the month, the results should be for the month that is on top of "First week", displayed for "First week, Second week, Third week and Fourth week". Note: Column A is in text form, while Date is mm/dd/yyyy Number Date Amount January 2024 January 2024...

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 I'm trying to find a way to automatically translate texts in Excel, but none of the functions I have found work. The company where I work seems to have many security levels so that's why I have limited options. I already tried the following ones: *Add-ins-> Blocked by the company *Google...

Hi Team, Greetings! I need a help here, I have created an excel template in which the workbook has n numbers of checkboxes. I don't want end users to do the right click and change the checkbox properties. I want to lock all the checkboxes so that users can only check or uncheck the checkboxes...

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...

I require a textbox to change the font size of text dynamically based on number of characters in the text Initially the size is 14 if no. of characters < 20 size = 14 if no. of characters > 20 and < 25, size =13 if no. of characters > 24 and < 30 size = 12

I have an excel sheet named “Eng Q” that I am needing only the files and folders put into from Z:engineering/program. Just a list of what’s in that main folder. Is this something that can be obtained when I open the excel sheet. Just need file name, date and file size to show up in columns A,B...

I need to take column B and C and highlight the duplicates. I have over 32000 rows in the spreadsheet. =SUMPRODUCT(--($B1:$B32244=$B1),--($C1:$C32244=$C1))>1 This solution works, but a) I don't know what it does and b) when I try to sort excel goes into Not Responding. Any ideas how to make...

Hi The below selected textbox is locked and fixed as seen in the properties panel. FYI the sheet is also protected. The issues exists for all the textboxes the below sheet.

I've read a lot of threads and usually manage to find my answers, but haven't quite managed on this occasion. I have a period start date in b1 Period end date in b2 The first date of the biweekly occurrence in b3 Based on the payment being fortnightly, I need to calculate how often it will...

Hi all, I am trying to create a word document with inputs from Excel. Everything has been working well until I tried to create a bulleted list. The relevant portion of my code is posted below: Set wdApp = New Word.Application With wdApp .Visible = True .Activate...