Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    11
    Views
    622

    Re: Using an Inputbox

    I actually was able to leave Msg in the InputBox code, the error handling resolved the problem. Thank you again!
  2. Replies
    11
    Views
    622

    Re: Using an Inputbox

    That made it work! Thank you guys so much for your help and persistence. Any idea why it took all that error handling to make it work? I don't understand why this had to be so complicated =P
  3. Replies
    11
    Views
    622

    Re: Using an Inputbox

    Yes, when the inputbox pops up, I select a cell on the screen and hit 'ok' on the inputbox, which is when the program crashes.
  4. Replies
    11
    Views
    622

    Re: Using an Inputbox

    If it helps at all, I am noticing that when I hit "debug", the value in StartCell is "Empty". So it does not have a cell reference to activate? Not sure why it is doing that....
  5. Replies
    11
    Views
    622

    Re: Using an Inputbox

    Thanks for the advice shg! Unfortunately it still gave the same error =/
  6. Replies
    11
    Views
    622

    Re: Using an Inputbox

    Thank you very much for your quick response, Joe. However, that did not work. I received the same error on the line "Range(Startcell).Activate" (which is where the error was before)
  7. Replies
    11
    Views
    622

    Using an Inputbox

    I've used inputboxes in the past and I do not know why I am having so much trouble now, but here is what I have:



    Public StartCell As Variant
    StartCell = Application.InputBox(Msg, "Select a...
  8. Replies
    5
    Views
    6,259

    Re: Checking a Check Box using VBA

    Ah ha! That worked! Thank you very much!
  9. Replies
    5
    Views
    6,259

    Re: Checking a Check Box using VBA

    Thank you very much for the response, but that doesn't seem to work for me. I get the error "Run-time error '438': Object doesn't support this property or method".
  10. Replies
    5
    Views
    6,259

    Checking a Check Box using VBA

    Hey everybody,

    I'm just wondering if it's possible to check or uncheck a check box in VBA? If it is, I would really like to know how please =)
  11. Replies
    2
    Views
    326

    Re: Using the Find command

    That did it! Thank you very much =)
  12. Replies
    2
    Views
    326

    Using the Find command

    Hello,

    I seem to be having some troubles using a find command in vba. Here's what I have:

    [code]
    ActiveSheet.Range("B16:AI68").Find(What:=":", LookIn:=xlFormulas, After:=ActiveCell, _
    ...
  13. Thread: 1048576 Rows

    by NathanW
    Replies
    2
    Views
    2,830

    Re: 1048576 Rows

    Had tried that too and it said it was too much to do all at once and that I needed to select a smaller range... But, no idea what I did, but it works now actually =P Thanks tho! I appreciate the...
  14. Thread: 1048576 Rows

    by NathanW
    Replies
    2
    Views
    2,830

    1048576 Rows

    Hello,

    Really not sure what is happening, my excel sheet says (through the vba code ActiveSheet.UsedRange.Rows.Count) that my last used row is the row 1048576. I have selected all beyond the scope...
  15. Re: Need to get column number from InputBox selection

    So what I've decided to do at this point is take the value of the selection (with rng2 dimensioned as a variant) and use that value in a Cells.Find.Activate command, then using iColNumber =...
  16. Re: Need to get column number from InputBox selection

    Hm, interesting. I suppose that would explain it then. But then shouldn't I be able to use 'On Error GoTo 0' just before using the 'On Error Resume Next'? Or does the 'On Error GoTo 0' classify as an...
  17. Re: Need to get column number from InputBox selection

    Isn't that strange? I don't understand why it's getting hung up even after the 'On Error Resume Next' statement...
  18. Re: Need to get column number from InputBox selection

    I spoke too soon... that returned the 424 error again when I hit 'cancel'.... ='( so ignore that last statement I made, lol
  19. Re: Need to get column number from InputBox selection

    I figured it out! I made the following change:



    rng2 = Application.InputBox(prompt:=Msg, Type:=8).Column



    And that did the trick! Thank you very much for your time and assistance guys!
  20. Re: Need to get column number from InputBox selection

    Ah, perhaps I should have specified better, the program works fine if I am choosing 'cancel' when going to insert a new column, but if I do choose to insert a new column and I select a cell on the...
  21. Re: Need to get column number from InputBox selection

    kevatarvind, this is the second day in a row now you have come to save my butt! That got rid of the error when I hit 'cancel' during the 'insert new column' part, but now it gives the error 'Run-time...
  22. Re: Need to get column number from InputBox selection

    Thank you very much daverunt for your response! But unfortunately no, it does not work =( Error handling techniques don't really seem to work on this type of error for some reason.
  23. Need to get column number from InputBox selection

    Hey guys,

    I'm having some trouble with an input box command. I'm creating a program that transfers data from one worksheet to another (within the same workbook) and the data is sorted by column...
  24. Re: VBA, InputBox, Run-time error '424': Object required

    kevatarvind you are the greatest person that has every lived, THANK YOU SO MUCH!! That has been driving me crazy for days now!
  25. Re: VBA, InputBox, Run-time error '424': Object required

    Thank you both very much for you assistance thus far, I really appreciate it! Gary, unfortunately with your code I am still getting the same error =(

    I will provide the full code, however, it is...
Results 1 to 25 of 27
Page 1 of 2 1 2