vba

Hello, Column J has a data validation list with the following 3 options: 1. Pending 2. Fit for work 3. Not fit for work I would like to add VBA which converts the row (from A to I) into values only (i.e converts any formulas into values) when "fit for work" or "not fit for work" is selected...

Hello everyone! I know excel well, but I don't know vba. I would be grateful for any help. Based on the table (М-55 МP) i need to use any tool to build a module that, when checking a product line with options, would automatically display its production date. Line to check -...

HI I hope you can help, I have been looking online and either I dont have the feature or i cannot do it. I have a table Column B to F and I want to hide the row if column F shows the word Completed. I have looked at conditional formatting but cannot find how to hide, not even sure where to...

I can't seem to get this VBA to go to E15 ! Otherwise, it is fine. Private Sub Worksheet_Calculate() If Range("E24").Value > "1" Then MsgBox "CLEAR" ActiveSheet.Range("E15").Select End If End Sub Thanks

For some unknown reason, whenever I paste a letter in cell e2 that is the same as the first letter in cell e9, it Autocompletes rather than just keeping the one letter "F". If I shut off Autocomplete it works fine. Similarly if I move "FLAME" to another column it also works fine. This happens...

Hi Good People, Currently I am working on a tool that would extract Reflection Workspace data to an excel file. The proble is, there are multiple pages or screen of a specific screen. Like for example. I managed to copy the first page of the screen, then you have to press page down key inorder...

I have this code that sends a range as a picture into an outlook email. I added checkboxes and want to be able to modify the code to send the contents in range B4:B17 and one or all of C,D, and E depending on if the checkbox is true. I have no idea how to do this, can anyone help me? Sub...

I have the following code that works most of the times, sometimes if gives me this error when using it consecutively too quickly: Run-time error 1004 CopyPucture method of range class failed. But I guess I can live with that :( What I need is to be able to add add text before the picture in the...

I have a spreadsheet with multiple tabs. In the tab titled "Cal/PM", The user will make an entry in Column A, and is supposed trigger the code below: Dim Asset As String Dim spec As String Dim cal As String Dim pm As String Private Sub Worksheet_Change(ByVal Target As Range) ' Check if the...

I have 02 issues with autocpmplete.... first - I have a worksheet with multiple pages (alomst 30 pages) and autocomplete only work in the current page but when I scroll down to insert data in a new page it doesn't work second - another worksheet with a table and I have 4 coulmn where i insert...

' Spot = Spot Price of the underlying ' K = Strike Price ' T = Option Maturity in Years ' rf = Interest Rate in decimal (i.e, for 5%, use 0.05) ' vol = Yearly volatility of the underlying in decimal ' n = Number of time steps ' OpType = 'C' for Call and 'P' for Put ' ExType = 'A' for...

Hello! I have prepared a document in which about 50 volunteers must indicate their availability on certain dates each month. The columns in which they indicate yes or no should always open for editing, for anyone. In contrast, columns A through L contain information they should never be able...

Hi, I need VBA code to get the list of top 10 recently modified files on the excel ribbon as macros in excel ribbon. The list of these files must be obtained from the Sharepoint link.

Hello All. I created a macro wherein the data captured from SAP and imported via power query will automatically pasted on another sheet of the same worksheet, what happened is that even though the query is updated once I ran the macro it captured the previous data generated from power query...

i am a beginner at vba, and am building a code to automatically clear text in column J when text in either column H or I is removed. i have this code already, but text in column J is cleared only when text in column I is removed. when i tried removing text in column H, text in column J doesn't...

Upfront Admission: My VBA skills are limited to one lines of code and plagiarism. So I will be zero percent offended if spoken to like a Excel baby. That said. I am working on a Power Query file that is reading a folder location of PDF files. From those files, I scrape out permanent information...

Hi, I created a UserForm to enter data into a worksheet. In that UserForm I have a button that opens a ListBox showing all the records stored in the worksheet. I want to filter this ListBox using a ComboBox based on my "Area" column. I populated the ComboBox using unique values from the column...

How can I reference the listobject when I copy the worksheet within the workbook? For example: MyTable is the current name of the listobject in the worksheet MyWorksheet.

Seen many close answers to my simple question, but is there an elegant way to use the Application.Match function for 2 criteria to match against 2 columns key1 = "QI" key2 = "Episode" keycol1 = 2 keycol2 = 6 application.match on 1 criteria works perfectly row = Application.Match(key1...

I have this spreadsheet with 255 RGB Codes. I need a code to convert them to the Natural Color System (NCS). I've tried AI solutions, which gave me VBA codes but they don't seem to work. Example of AI generated VBA code: Function RGBtoNCS(r As Integer, g As Integer, b As Integer) As...