Search:

Type: Posts; User: VBE313; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    5
    Views
    127

    Re: Web scrapping with JAVA based website

    You would have to use WScript.Shell since it has a waitOnReturn option.

    Reference: https://stackoverflow.com/questions/15951837/wait-for-shell-command-to-complete
    <code style="margin: 0px;...
  2. Replies
    5
    Views
    127

    Re: Web scrapping with JAVA based website

    Yes Buddy I am sure.

    here is an example of some code within a sub procedure

    bot.FindElementById("R_T_ENTRY_WEB_ACTIVITY_ID$0").Click...
  3. Re: Easier Way to Write Nested IFs and Iterating Offsets

    Thank you, Dante!
  4. Replies
    5
    Views
    127

    Re: Web scrapping with JAVA based website

    Hi,

    Application.Wait is what i use.

    https://docs.microsoft.com/en-us/office/vba/api/excel.application.wait
  5. Replies
    11
    Views
    94

    Re: Loop through an Array, change values

    Hello,

    The Following UDF Grabs the number. https://www.extendoffice.com/documents/excel/1622-excel-extract-number-from-string.html

    Function ExtractNumber(Cell As Range)
    Dim i As Long
    ...
  6. Re: Not allow users to hide columns in protected sheet

    Sub lockActiveSheetFormatColumns ()
    ActiveSheet.Protect Password:="EnterPasswordHere", AllowFormattingColumns:=True
    End Sub
  7. Easier Way to Write Nested IFs and Iterating Offsets

    What is a less rigorous way or writing this?


    Sub COSTPLANBREAKDOWN()
    Dim rngstart As Range
    Dim tst As Range, lastrow As Long
    Dim cl As Object
    Dim L As Long, strcells As...
  8. Re: UDF involving Split function or Formula Text?

    mikerickson,

    Thank you very much! It is doing what I wanted and was even easier than what I had.

    THANK YOU!
  9. Re: UDF involving Split function or Formula Text?

    SOLVED!
    https://www.exceltip.com/tips/how-to-extract-nth-word-from-text-string-using-vba-in-microsoft-excel-2010.html

    Function ExtractNthWord(x As String, y As Integer)
    Dim word() As String
    Dim...
  10. Re: UDF involving Split function or Formula Text?

    I got this function from here and it gave me the all the numbers listed out in commas,
    ex:) 1,0.18,10,50,20

    How can I get these numbers separated?
    ...
  11. UDF involving Split function or Formula Text?

    I created a UDF that calculates how many minutes it takes to complete a certain task.

    (ex: =MinutesToComplete(1,0.18,10,50,20) )

    Is there a way to extract each argument/parameter?

    (ex:...
  12. Thread: Udf vlookup

    by VBE313
    Replies
    1
    Views
    136

    Udf vlookup

    I have a table of items that are assigned a fixed cost.
    Example:
    Item) Name) Price
    1) Red Ruby Shirt) $35.22
    2) Blue Tuxedo) $47.90

    On a...
  13. Replies
    3
    Views
    68

    Re: adding error handling to UDF

    Thank you, Fluff!
  14. Replies
    3
    Views
    68

    adding error handling to UDF

    How can i better write this code and add error handling?


    Function TotalStainless(EasyorHard As Double, Thickness As Double, NumOfPierces As Double, HoleCutLength As Double, TotalPerimeter As...
  15. Re: How can i replace this "a" without application ran code?

    Hi mikerickson,

    Thank you for that! I have to use this code for 45 columns, which code would be faster?
  16. Re: How can i replace this "a" without application ran code?

    Joe4,

    Thank you so much!!
  17. Re: How can i replace this "a" without application ran code?

    Hi Joe4,

    I am trying to calculate a bill of materials. For example... If it says "Yes" in column A, then calculate all of the ones below it until there is a "Yes" again. For column C, to get 19,...
  18. How can i replace this "a" without application ran code?

    How can i replace the bold part?


    Function test1234()
    Dim a As Long
    If ActiveSheet.Name = "Sheet1" Then
    Else
    End If
    a = Application.Caller.Row + 1
    Do While Cells(a, 1).Value <> "Yes"
  19. What does this mean on Microsoft’s website?

    Can someone please give me a detailed example of what this means?

    Do not use forward referencing and backward referencing

    To increase clarity and avoid errors, design your formulas so that they...
  20. Re: How to Offset Column in this Multi Select Listbox?

    Thank you Very Much!!
  21. How to Offset Column in this Multi Select Listbox?

    I got this code from OnlinePCLearning. How do I offset every other column?

    Private Sub cmdAdd_Click()
    Dim addme As Range, cNum As Integer
    Dim x As Integer, y As Integer, Ck As Integer
    ...
  22. UDF Loop Freezes Unless Calculating in The Sheet it’s in

    I have multiple UDFSs that loop through cells, I have application.volatile on them with worksheet change events that calculate the sheet. But if I am in a different sheet and press calculate, it...
  23. Excel Sheet Broke After UserForms With Pictures

    What is the best way to add a picture to a userform? .jpg? .gif? .png? etc.
  24. Cant Click or Change Value SeleniumBaisc VBA

    <inputname="ri_tl_entry_web_ri_date_worked$0" tabindex="49" class="PSEDITBOX" id="RI_TL_ENTRY_WEB_RI_DATE_WORKED$0" aria-required="true" style="width:71px; "...
  25. Re: How can I select the next item and next item and next item?

    Fluff,

    Thanks again! This selects the next items on the list. I just need to add a better filter.
Results 1 to 25 of 70
Page 1 of 3 1 2 3