Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    6
    Views
    2,062

    Re: TextBox Control (VBA/Excel 2003)

    HansV,
    Thanks a lot. I wonder why MS didn't implement coding for the BeforeDragOver or BeforeDroporPaste events? Anyway, I will try your suggestion today.

    Howard B
  2. Replies
    6
    Views
    2,062

    Re: TextBox Control (VBA/Excel 2003)

    Thanks HansV for your response. I think I may get a chance to try your suggestion today. This is what I am working with, a UserForm containing a TextBox and CommandButton. I was trying to allow the...
  3. Replies
    6
    Views
    2,062

    Re: TextBox Control (VBA/Excel 2003)

    Well I tried recording a macro using the save function and this is the results:

    Sub Macro1()
    '
    ' Macro1 Macro
    '

    '
    ActiveCell.FormulaR1C1 = "=SUM(R[3]C[-1]:R[10]C[-1])"
    End Sub
  4. Replies
    6
    Views
    2,062

    Re: TextBox Control (VBA/Excel 2003)

    So far, you have confirmed the conclusion I came to. However I noticed that the MS Excel select function feature has the capabilities I am looking for. When you click the select function icon, it...
  5. Replies
    6
    Views
    2,062

    TextBox Control (VBA/Excel 2003)

    I can't figure out how to drag and drop or paste information from a cell into the TextBox.text control on a Userform. If someone could help me with this problem I would greatly appreciate the help.
Results 1 to 5 of 5