Search:

Type: Posts; User: bushmobile

Page 1 of 13 1 2 3 4

Search: Search took 0.38 seconds; generated 56 minute(s) ago.

  1. MsOf10 Re: VBA XML Ribbon Callback to xlam Class Instance?

    doesn't seem to matter where I put the class instance, I've tried both in ThisWorkbook and in a module - it says i can't find the macro.

    Also tried referring to the class instance without the...
  2. MsOf10 VBA XML Ribbon Callback to xlam Class Instance?

    I'm building an xlam add-in and whilst I'm able to callback to standard module subs, I'd like to be able to callback to an instance of a class module

    I'd tried something like the below, but it...
  3. Re: [RESOLVED] Like operator with wildcards in String Search

    well if you wanted to one-line it as much as possible then you might be able to do something with RegEx? not something i've really ever used though
  4. Re: Like operator with wildcards in String Search

    what's the issue with InStr?

    use x as the seed for the InStr that returns y

    and a tweak on your mid: Mid$(myText, x, y - x + Len(searchString2))

    it'll certainly be faster than using Like
    ...
  5. Re: Like operator with wildcards in String Search

    *time*good* for the match, but it won't help you extract the string, because you don't get any info back from like
  6. Replies
    5
    Views
    2,348

    VS 2012 Re: Non-Breaking Space in Label Control

    thanks
  7. Replies
    5
    Views
    2,348

    VS 2012 Non-Breaking Space in Label Control

    Is it possible to have a non-breaking space in a label?
  8. Replies
    1
    Views
    545

    VS 2012 Panel inside Usercontrol

    I have a Panel on a UserControl - and I'd like to be able to drop controls, at design time, on to that Panel when the UserControl is on my form.

    I can drop controls on to my UserControl fine, I...
  9. Replies
    3
    Views
    804

    VS 2012 Re: Typed Dataset and Bound Controls

    Cheers jmcilhinney, that's definitely put me a step in the right direction, and after tweaking my relationships in the dataset designer, I've got my three BindingSources connected to each other.
    ...
  10. Replies
    3
    Views
    804

    VS 2012 Typed Dataset and Bound Controls

    I have a typed data that I've created that links the table 'Contacts' to the table 'Clubs' via a table called 'ClubContacts' - e.g. there's a relation between 'Contacts' & 'ClubContacts', and a...
  11. Re: [.NET 3.5+] ShellFile - Managed Wrapper To Retrieve Extended Properties

    For those people who are having problems getting it to return any values - you may not be showing file extensions in Windows Explorer. The ShellFile.vb GetCollection procedure is trying to compare...
  12. Re: Can someone help, with this source code!!

    Even if someone did rewrite that so it was the pictureboxes that were removed rather than the form, I still don't think it's going to help you, as mouse clicks would pass straight through to the form...
  13. Re: How can you tell if the CTRL button was pressed in _KeyPress?

    That isn't the right place to do it - I don't even think you can
  14. Re: How can you tell if the CTRL button was pressed in _KeyPress?

    What you need would be dependent on what you were actually trying to do - but to specifically see Ctrl+1, the following would be one possible solution:
    Private Sub Text1_KeyDown(KeyCode As Integer,...
  15. Replies
    5
    Views
    866

    Re: Mathematic expressions in a textbox!

    if you've already added one to the form, then there's no need to try and create another:
    Private Sub Command1_Click()
    Label1.Caption = ScriptControl1.Eval(Text1.Text)
    End Sub
  16. Replies
    5
    Views
    866

    Re: Mathematic expressions in a textbox!

    show us what you tried - the script control can do what you want.
  17. Replies
    16
    Views
    1,432

    Re: Redrawning Mshflexgrids eractic

    you'll probably need to post some code then
  18. Replies
    16
    Views
    1,432

    Re: Redrawning Mshflexgrids eractic

    are you setting the MSFlexGrids to .Redraw = False before altering them?
  19. Replies
    4
    Views
    696

    Re: text = combo help

    if you put the Text1.Text = Combo1.Text in the _Change, _Click and _KeyPress events you should cover all eventualities.
  20. Re: Using variables to store equations

    As long as your formulas are always laid out in full (e.g. A * B + C rather than AB + C) then you can do something as simple as just using the replace function to put the values in the correct place:...
  21. Re: Using variables to store equations

    Have a look at the Microsoft Script Control - you can give it a string equation and it will evaluate it:
    Private Sub Command1_Click()
    MsgBox ScriptControl1.Eval("2^(1+2)")
    End Sub
  22. Re: Referencing control array in frame

    Just refer to them as txt(0), they don't sit under the frame object
  23. Re: Can we compare enum value with a double value?

    not too sure what you're on about:

    (1000 <> 1000) = False

    Is 1000 greater than or less than 1000? No, so you get False.
  24. Replies
    7
    Views
    2,330

    Re: Pivot Table Source

    That doesn't seem to work. I get an "Application-defined or object defined error" trying to access the Source Data directly e.g.:
    Dim S As String
    S =...
  25. Replies
    7
    Views
    2,330

    Re: Pivot Table Source

    both pivots already exist in the spreadsheet
  26. Replies
    7
    Views
    2,330

    Re: Pivot Table Source

    Yeah, I've had a crack with that before - the code it gives you when you record the macro can't be applied it just errors for me.

    The code it gives me:
    Range("E8").Select
    ...
  27. Replies
    7
    Views
    2,330

    Pivot Table Source

    Anyone know how to set the source of one pivottable to that of another using VBA?
  28. Replies
    2
    Views
    448

    Re: Webrowser repeats loading sequence?

    The document complete event will fire for every frame - you have to check the pDisp object to see if it's the one you care about:
    Private Sub WebBrowser1_DocumentComplete(ByVal pDisp As Object, URL...
  29. Re: How to check if an index of a control exist?

    IsControlArrayMember
  30. Replies
    8
    Views
    9,811

    Re: MouseLeave event

    http://www.vbforums.com/showpost.php?p=2074669&postcount=31
  31. Replies
    2
    Views
    650

    Re: HTML Object Library & Message Box

    Hi Hack!

    I realised since it was just loading a new page (but with the xTransfer parameter set) I could just load that page directly using createDocumentfromURL

    Naturally, I realised this after...
  32. Replies
    2
    Views
    650

    HTML Object Library & Message Box

    Hey guys - long time no ask a question

    I'm using the HTML Object Library to navigate a web page and automate a process. A one point a message box comes up asking me if I wish to proceed.

    The...
  33. Thread: FindWindow

    by bushmobile
    Replies
    7
    Views
    786

    Re: FindWindow

    Find Window by Partial Caption
  34. Re: How to check Control Array for....?

    you can loop through using a For Each loop:
    Dim lbl As Label
    For Each lbl In myLabels
    Debug.Print lbl.Index
    Next lbl
  35. Replies
    8
    Views
    987

    Re: Splitting numbers...

    or
    Dim lPos As Long

    lPos = InStrRev(yourdata, ":")

    MsgBox Left$(yourdata, lPos - 1)
    MsgBox Mid$(yourdata, lPos + 1)
  36. Replies
    37
    Views
    2,186

    Re: finding someone's age

    what do you mean?


    and if anyone's bothered to read down this far, here's the age calculation without an if:
    Private Function GetAge(ByVal DOB As Date) As Long
    GetAge = DateDiff("yyyy",...
  37. Replies
    5
    Views
    702

    Re: form transluscent but controls opaque

    as Fazi mentioned - you can make an approximation with 2 forms, but it only works well with small forms (if you move the form about / resize it) because of the amount of drawing that the system has...
  38. Replies
    5
    Views
    730

    Re: What is MY handle???

    if you're doing everything right then it will give you the same number - you must be doing something wrong - but without seeing code I wouldn't be able to tell you what.
  39. Replies
    5
    Views
    730

    Re: What is MY handle???

    you shouldn't do - they should give you the same result:
    Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" ( _
    ByVal lpClassName As String, ByVal lpWindowName As String) As...
  40. Replies
    17
    Views
    1,168

    Re: Arrays and IF statements

    Select Case True
    Case today = sunny

    Case ispayday

    Case carhasgas

    End Select
Results 1 to 40 of 499
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width