vba

  1. B

    Dynamically Create and Fill Value of Userform Textbox in VBA

    Hi Community, I am stuck in a VBA conundrum. I am trying to create multiple UserForm Textboxes in vba and Fill each one with a unique value either by index, or by some other means. I am able to get them to fill but when I do it seems that all the text boxes are being filled with the same values...
  2. H

    Insert bulk hyperlink from Excel list to PowerPoint

    Hi I have PowerPoint has 83 slides each slide have 12 images and 12 textboxes (textbox names for each slide start from 1 to 12) What I'm trying to do I have excel sheet which has all my data Column A has a slide number For the PowerPoint Column B has textbox name Column c has a title which...
  3. 3

    VBA macro: insert row if condition is met and apply formula

    Hello, I was hoping someone would help me. I would like to conditionally add a row to a sheet in my workbook. I have about 30 different rows of descriptions (A1) and data(B1) on "Sheet4" and I would like to add a row to "Sheet5" if the data from "sheet4" B1>0. If this condition is met a row...
  4. W

    Locking cells in a row based on another cell's content

    I am trying to figure out a way in VBA to lock cells in columns A:C if the corresponding cell for that row in column D reads "Complete". So If D2 reads "Complete", A2:C2 will be locked, if D3 reads "Complete" then A3:C3 will be locked, and so on. Similarly, if D2 reads "Open" or is blank, cells...
  5. Z

    Excel/VBA Question

    I am trying to determine if this is even possible within excel: I have a Summary Tab with a list of different customers in it. I also have a "Dashboard" tab that is an dynamic/filterable dashboard with slicers. On this dashboard, you can select which customer you want to view via the Slicer...
  6. B

    Return server error from function as string?

    I have an Excel VBA function that takes a URL and returns a response. response = GetHTTP(.ListColumns(colNameURL).DataBodyRange(n).Value) ... Public Function GetHTTP(ByVal url As String) As String With CreateObject("MSXML2.XMLHTTP") .Open "GET", url, False: .Send GetHTTP =...
  7. K

    @ How to lock cell after click check box tick mark?

    Kindly Find Result....in Above Question...
  8. B

    VBA SQL Query ACCESS DB w/ LIKE "*" Operator

    Hi Community, Looking for some help in solving a problem. I am getting back a NULL (no records it seems) when processing this query in VBA, but when i try it similarly in Acess it works the way it's supposed to. Not sure what i am doing wrong here. Any help would be appreciated. VBA SQL...
  9. ScottDarth

    VBA ODBC Activity is crashing Excel

    I'm trying to write some code that will iterate through rows in an Excel spreadsheet (I'm using Excel 365 Version 1908). For each row, it'll check to see if that row's "unique identifier" exists in a database. It *happens* to be a DB2 database, but it could be any ODBC source. I'm trying to...
  10. E

    How is Access changing my Excel file?

    I create low-level automation solutions with Excel, these are usually small tools that accept user inputs, preform data calculations/manipulations, and generate outputs. I recently ran into a file-compatibility issue and need help. I am one small cog in a very large company and have no control...
  11. F

    Select Value on OLEP Cube

    Hi To all, I am kind of new working with OLEP Cube, I Record a Macro with Macro Recorder that works nice, but I need to substitute a Value with an User Entry, This is the original Code that I have that works Fine ActiveSheet.PivotTables("PivotTable1").PivotFields( _ "[Profit...
  12. D

    (Fast read!) Send out email automatically with attachment through command button

    Hello everybody, Goal: I am currently trying to create a command button in Excel that, when one clicks on it, sends out an email to me with an order that one has entered into Excel. The following link here: Using Excel VBA to Send Emails with Attachments - wellsr.com has a nice VBA code that...
  13. A

    Historical Database Excel/Macro

    Hello, I'm trying to build an historical Database that let's me know what changes in previous record. For example, I have 5 different workbooks for each country with same tables. So first I need to consolidate it monthly since users are putting their values and changing it every period. To be...
  14. H

    Excel VBA Display text box vs. Input text box values fail to transfer with display text box method, Compile error: Method or data member not found

    Hi, I have 2 scenarios where: 1. I have an integrated VBA form where values are input manually in a textbox and I get results outputted successfully. I was able to find an i.e. =embed((m1r1) command in the textbox but can't seem to access it again. The first sheet has code like this...
  15. A

    UnZip all files in specific folder

    Hello guys, I have a code where it will unzip specific file based on file path provided. But I want to unzip all zip files present in the folder. Public Sub Unzip() Dim localZipFile As Variant, destFolder As Variant Dim Sh As Object localZipFile = "C:\folder\path\test.zip"...
  16. A

    How to Move to Next Row, start over, unless blank

    Hi, I've written a macro to take an employee database Sheets("CEP Program"); copy a row representing a single employee & their information to a source sheets("Source Data") and then use the values in Source Data to fill a form in Sheets("Verification Sheet"), and print the Verification sheet...
  17. R

    VBA: Trying to delete all but the first row of a table

    I want to delete all rows in a table EXCEPT for the first row in the databodyrange. Using tbl.DataBodyRange.Rows.Count, I plan to delete that many -1. The problem I'm having is figuring out how to select my starting row in the databodyrange down to the last row of the table. I thought of using...
  18. S

    Unable to find element after clicking submit button in VBA using Selenium

    I have an issue with the loading of web page after the whole form is filled neatly. The next page is where i need to do data extraction. This is the website: https://enquiry.icegate.gov.in/enquiryatices/sbTrack Please find sample data here : SELECT LOCATION : HYDERABAD ICD (INSNF6) ENTER...
  19. montecarlo2012

    VBA: Column headers how to make it work

    Hi. I make it work some simple and basic loop, the idea just add each row on column A and B and the total on C, for that I write the following code and work good. Sub g_one() Dim x As Long, y As Long For x = 1 To 4 For y = 1 To 2...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top