Search:
Type: Posts; User: Resource Dragon
Search:
Search took 0.04 seconds.
-
I'm possibly being a bit picky here but I would put the Choose Operator frame in between the two number text boxes and label the radio buttons "Plus", "Minus", "Multiplied by" and "Divided by",...
-
I think the moderator needs to move this question into Office Development.
That said, the good people at VBForums helped me with searching through sub-folders using the following code. (I was...
-
Aside: If your users are compulsive date dotters, you can always look at inserting a routine to change any dots in the date range (your A4:C8 above) to slashes or hyphens. It's a little extra work...
-
That's what I thought. They do selective Windows updates. I might try my search again, in case I searched wrongly. Along with the selective Windows updates, they also do selective deletions, e.g....
-
For the record, I checked on the .NET framework and discovered it was ... FW1!
-
Wow, guys! Thank you for all the info & discussion. As I'm sure you've deduced, I am very much a beginner in the world of .NET. I would agree with Niya's last comment.
-
Dear tg
I'll try that. (I'll search for the FW2 before attempting to recompile!) There are apps that live in the various drives, so someone must have found a way of getting them to work. [If...
-
UNGG! Largely due to my ignorance, (combined with issues of the network on which the program needs to run) I might have to fall back on VBA & putting the project in a Word or an excel file. As this...
-
I am having a few dramas with running my completed project on another computer. I created my project using Visual Studio 2010 (Microsoft Visual Basic 2010 Express).
The error messages I get say...
-
I'm not sure that what you want to do is possible. The best I can suggest is two text boxes (or labels) that look like one but are in fact separate entities and then you can code the colour for each....
-
The "Leave" event does the trick. Thank you all.
-
Thank you both. I'll need to fiddle a bit more, as the TextChanged event (which is the default VB.Net provides) isn't quite what I want. I need something like AfterUpdate or Exit.
-
Please excuse a beginner in VB Net with what is probably a really dumb question.
I am trying to write some code that will format the text in a text-box as currency, so that if the user enters "6",...
-
The code below assumes that you have a userform with two text boxes and a command button. I've also got a fairly limited number of rows of data that I'm working with.
Private Sub...
-
Dear tg
Thank you for your reply. Questions always make much so much more sense to the writer than the reader!
The following code seems to be doing the trick:
Sub GetTempFolder_2()
...
-
I am trying to get into sub folders inside a special folder (the temp folder) programmatically and I am not having a lot of success. With Microsoft Scripting Runtime added to the references, the...
-
I haven't programmed a calculator but I have written programs that add and multiply busily. To do that, instead of having "firstnumber" and "secondnumber" and so on, I used arrays.
Once you get...
-
You’ve lost me. Which expression returns a MailMerge object? If I try using, say, wrdDoc as a MailMerge object, VBA complains that the object or method is not recognised.
-
I recorded a macro in Word, and this is what I got:
Sub Macro1()
'
ActiveDocument.MailMerge.MainDocumentType = wdFormLetters
Selection.TypeText Text:="Dear "
...
-
Dear Pete
I'm not quite sure what you mean by "make it into a merge document", if I'm looking at Word 2007 I've got options like template & macro-enabled (or I can have a regular document). Am I...
-
G'day. I was hoping someone could please do me a small favour. I have Office 2007 and I need some info from Office 2010.
What I need is for someone with Office 2010 to open a new file in Excel,...
-
No, wrdDoc is a new, blank document until the code populates it, based on choices the user has made. (The code lives in an excel file, and opens word and outlook.)
I've tried recording a macro in...
-
I am trying to insert a mail-merge field and I can't find the correct syntax.
This is what I've got so far and it doesn't work.
With wrdDoc
.Content.InsertAfter Format(MyDate, "dddd, d...
-
Yes, using a "click" event with both combo-boxes solves the problem. Thank you for spotting that.
-
-
Oops! I don't appear to have succeeded in uploading the file!
Ah, well, here is the code instead:
Dim row_number As Integer
Dim the_row As Integer
Dim Range3P As Range
Dim RangeOP As Range...
-
I’ve got a problem with a user form which has two radio buttons and two combo boxes. The rowsource depends upon which radio button the user clicks. (See attached file.)
The user chooses a radio...
-
The code "If Val(ComboBox1) = Sheets("Sheet3").Cells(i,1) " works for the numbers but not for the strings. If, however, I amend the code to:
Private Sub Frequencies()
For i = 2 To 5
If...
-
Long numbers are like: 123456 or 89756259 or whatever. My strings look like: 05-E235664 or A908645 or 07-E34608 or whatever.
-
I have created a combo box that picks up data from a column in an excel spread-sheet. I then want my code to populate various other labels and text boxes in my userform using the value in the combo...
-
This may be a rather simplistic approach, but would something like:
Private Sub txt_colour_AfterUpdate()
If txt_red = "Red" then
optRed = true
End if
end sub
do the trick?
-
Dear Sid
Thanks for that. Much appreciated. Best wishes for Christmas & have a happy & safe holiday season.
cheers
The Dragon
-
G'day. I was hoping someone could please do me a small favour. I have office 2007 and I need some info from office 2003.
What I need is for someone with Office 2003 to open a new file in Excel,...
-
For rusel and westconn1: The
[CODE]WordBasic.MailMergeUseOutlookContacts[CODE]
line came from recording a macro in Word 2007! (I did think it looked a bit odd...)
I have considered using...
-
I've got some of the way along with this problem - apologies for the delay in postings but I've had internet dramas. The problem I have now is telling Word where I want it to insert the merge field....
-
Dear Stanav
That didn't quite work but it pointed me in the right direction. I then went to Tools > Internet Options > Advanced and clicked Restore Settings. So I'm now back on the internet. Yay!...
-
My PC has two user accounts. I am the Administrator. My profile was infected by a virus. It wouldn't let me open any programs from the desk top or the start menu. The other profile was not affected....
-
Not necessarily. You might, however, need to make up a larger array (say an n x 4, or n x 5) instead of the n x 3 I used to illustrate the principal. The sheet you set up with the names of the...
-
Thanks, Pete. I'm working on it, I'll let you know how I got & if I get something working nicely, I'll post it.
cheers
The Dragon
-
Interesting! I wasn't aware of that.
|
Click Here to Expand Forum to Full Width
|