Search:

Type: Posts; User: Richard U; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    4
    Views
    148

    Re: VBA stuck in a loop I can't get out of

    Please let me know if it works :D

    Good luck!
  2. Replies
    4
    Views
    148

    Re: VBA stuck in a loop I can't get out of

    your need to change this....




    MyValue = InputBox(Message, Title, Default)
    If MyValue <> "Password" Then
    MsgBox "Invalid password - entry removed"
    Application.Undo
    Exit Sub
  3. Replies
    16
    Views
    464

    Re: Can anyone see why this would fail?

    Have you tried reinstalling office on these machines?

    We've had some of the most bizarre issues resolved by doing that.
  4. Replies
    16
    Views
    464

    Re: Can anyone see why this would fail?

    You may also want to try compiling the project again. It might help. Excel can get corrupted very easily
  5. Replies
    11
    Views
    1,005

    Re: disable check box based on other checkbox

    Yes, if a selection should preclude others, radio buttons are the way to go.
  6. Replies
    16
    Views
    464

    Re: Can anyone see why this would fail?

    The only thing I can think of is either file corruption, or for some reason garbage data getting in.

    First, I'd suggest changing the code slightly.




    Private Sub UserForm_Activate()

    ...
  7. Replies
    11
    Views
    1,005

    Re: disable check box based on other checkbox

    If you use the Enabled, then how would you enable once you've set something to enabled = false?
  8. Re: Formula to keep adding a 1 to a cell based on another cell value

    your best bet would be to use the change event on the worksheet.


    Private Sub Worksheet_Change(ByVal Target As Range)


    If Not Application.Intersect(Target, Columns(2)) Is Nothing Then
    If...
  9. Replies
    4
    Views
    112

    Re: TypeMismatch, run time error 13...

    try reversing these:



    Private Sub CBCusNewCus_Click()

    CustForm.Hide
    adnecustomer.Show

    End Sub
  10. Replies
    11
    Views
    1,005

    Re: disable check box based on other checkbox

    I suggest the radio buttons in a group as well, but here's the code if you can't use radio buttons for some reason




    Private Sub Chk_Both_Click()
    Me.chk_usa.Value = False
    ...
  11. Replies
    13
    Views
    1,122

    Re: Excel Spreadsheet running slow

    Turn off automatic calculations.

    1.Click the File tab, click Options, and then click the Formulas category.
    2.Click on manual under "workbook calculation"

    Click on "calculate" on the bottom of...
  12. Replies
    23
    Views
    559

    Re: VBA code to sort text BEFORE numbers?

    Option Explicit



    Sub sorter()
    Dim ctr As Long

    Range("A1:B10").Sort Key1:=Range("A1"), _
    Order1:=xlAscending, Header:=xlNo, _
    OrderCustom:=1, MatchCase:=False, _
  13. Replies
    3
    Views
    173

    Re: Copy paste by vba

    You don't want to copy and paste.

    You want to use two ranges, and set the value of one to the other.

    so you'd want something like this....




    Sub Mysub
  14. Re: Application-defined or object-defined error

    Baitmaster G

    option explicit revealed he had misspelled "start" as "strart" that will cause the error when it tries to redim
  15. Re: Application-defined or object-defined error

    Try this




    Option Explicit

    Sub Mine()

    Dim out() As Double
  16. Re: INDEX and MATCH when there are blank cells in column

    This comes up from time to time....

    Check here

    https://www.mrexcel.com/forum/excel-questions/955647-index-match-formula-exclude-blanks.html

    and here
    ...
  17. Replies
    2
    Views
    103

    Re: Copy paste repeat

    a quick macro should do it....

    assuming that the sheet you want to paste it to is the last sheet...




    Sub SaveMyFingers()

    Dim ws As Worksheet
  18. Replies
    1
    Views
    103

    Re: Help with a complex formula

    ugh, sorry....

    Correction...

    =OFFSET(INDIRECT("Customer!A" & MATCH("AB*",Customer!$E$1:$E$5001,0)+0),0,0)
    =OFFSET(INDIRECT("Customer!A" & MATCH("AB*",Customer!$E$1:$E$5001,0)+0),0,1)
    ...
  19. Replies
    1
    Views
    103

    Help with a complex formula

    I'm trying to break out customer data to several spreadsheets

    It's working, but I think there must be an easier way


    Here's what I have so far.....
    The customer name is in column "E" and I...
  20. Replies
    6
    Views
    120

    Re: Consolidate Workbook

    try:

    IF('Week 42'!D145 <> "",'Week 42'!D145," ")
  21. Re: vba to skip corrupt files needed (Excel crashes when trying to open)

    Thanks, but it didn't work. Excel still crashes. Great idea though.

    I found the file, and it crashes excel if you try to repair it manually too, or try to just get the data.

    Only choice is to...
  22. vba to skip corrupt files needed (Excel crashes when trying to open)

    We are upgrading to office 365 and excel 2016, and changing our directory structure.

    As part of this, we need to document which spreadsheets have links. I am literally checking tens of thousands...
  23. VBA to open a workbook without triggering open event?

    With office 365 on the horizon, I need to catalogue all of our spreadsheets, and identify links.

    I am doing this by creating a workbook object, setting the object to"




    Set wb =...
  24. Replies
    5
    Views
    136

    Re: Validate data pasted to a textbox

    Wow, thank you, this is pure gold.

    The isnumeric would have worked for what I was using, but this is much much better, and bulletproof. Thank you so much Rick.
  25. Replies
    5
    Views
    136

    Re: Validate data pasted to a textbox

    Thanks, worked like a charm!
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4