Search:
Type: Posts; User: bushmobile
Search:
Search took 0.53 seconds.
-
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...
-
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...
-
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
-
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
...
-
*time*good* for the match, but it won't help you extract the string, because you don't get any info back from like
-
-
Is it possible to have a non-breaking space in a label?
-
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...
-
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.
...
-
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...
-
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...
-
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...
-
That isn't the right place to do it - I don't even think you can
-
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,...
-
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
-
show us what you tried - the script control can do what you want.
-
you'll probably need to post some code then
-
are you setting the MSFlexGrids to .Redraw = False before altering them?
-
if you put the Text1.Text = Combo1.Text in the _Change, _Click and _KeyPress events you should cover all eventualities.
-
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:...
-
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
-
Just refer to them as txt(0), they don't sit under the frame object
-
not too sure what you're on about:
(1000 <> 1000) = False
Is 1000 greater than or less than 1000? No, so you get False.
-
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 =...
-
both pivots already exist in the spreadsheet
-
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
...
-
Anyone know how to set the source of one pivottable to that of another using VBA?
-
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...
-
-
http://www.vbforums.com/showpost.php?p=2074669&postcount=31
-
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...
-
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...
-
Find Window by Partial Caption
-
you can loop through using a For Each loop:
Dim lbl As Label
For Each lbl In myLabels
Debug.Print lbl.Index
Next lbl
-
or
Dim lPos As Long
lPos = InStrRev(yourdata, ":")
MsgBox Left$(yourdata, lPos - 1)
MsgBox Mid$(yourdata, lPos + 1)
-
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",...
-
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...
-
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.
-
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...
-
Select Case True
Case today = sunny
Case ispayday
Case carhasgas
End Select
|
Click Here to Expand Forum to Full Width
|