Programming

Reference Label from TextBox
I am using a class I found here that works very well for my needs. Now I would like to reference and change the caption of a label of the same name (number) as the text box. The Class: Public WithEvents txtBox As MSForms.TextBox, CtlNum As String Public laBl As String Private Sub Class_Terminate() Set ... 20 Jul 2008 13:30

set Object = Nothing
I see quite often Excel Sub's with following code Sub mySub() Dim myObject as Object set myObject = CreateObject("www.xx") ... (some code) ... set myObject = Nothing end Sub What is the use of setting a local variable to Nothing, as it will be destryed by End Sub ? Cheers, -- ... 21 Jul 2008 16:10

Export Data to Text file with fix format
Hello All, I am using Excel 2003 and have data in Range D10:Q(20,000+ rows). I wish to export the all active rows in the range in the Excel file to a text file (Notepad). Details are as follow: Col C (currently 4 digits) – to be exported (total 9 digits) with trailing blanks (eg. 1234 – should export as 1234(... 26 Jul 2008 07:54

Sorting issue has got me puzzled!
Hi all, I've tried numerous combinations of selection.sort in my code however none are working. I'm stumped however believe maybe have spotted a possible cause. My code is showing the word SORT in capitals (non defaulting to normal text as expected). I thought this may be because somewhere in my personal wb or t... 20 Jul 2008 09:23

Sorting issue has got me puzzled!
Hi all, I've tried numerous combinations of selection.sort in my code however none are working. I'm stumped however believe maybe have spotted a possible cause. My code is showing the word SORT in capitals (non defaulting to normal text as expected). I thought this may be because somewhere in my personal wb or t... 20 Jul 2008 10:24

Place VBA in cell on spreadsheet
I want tp place a Userform_checkbox in cell B3 - B8. I then want to use the true/false return from each box to place info from cells E3 - E8 in cells G3 - G8. I am VERY new at this and will take the advice to buy an Excel Bible by John Walkenbach. Thanks for your help. Slimjater ... 20 Jul 2008 19:39

Combining TextBox Values With Spaces
Greetings, I have four Textboxes on a UserForm that may or may not have anything in them. I am trying to combine the contents of the 4 TextBoxes plus one space between each value into a 5th Textbox. I tried brute force and ended up with a long sub (about 130 lines - long lines wrapped for legibility. Will post... 21 Jul 2008 07:55

If Value is > 0, in a named range ??
Hi, This topic has likely been covered a 100 times in this forum but I have been converting all of my hard coded ranges into named range for the sake of dynamic use. However, in this one instance, I am have a hell of a time; I keep getting a type mismatch. Does anyone see anything wrong with the below ... 20 Jul 2008 17:36

Input Question Help
Hi everyone, I was wondering if there is any function or VBA coding out there allow me to do this. Each time I type something into each cell in Range("B2:B100") it will display the time it was entered in (hh:mm) e.g. when I type "ABC" in B2 at 3:40pm it will display 3:40pm or 15:40 in cell A2. When I typ... 20 Jul 2008 04:18

Time stamp multiple cells changes when external database auto refreshes
I have a excel worksheet that is linked to a website. Every 60 minutes the web query refreshes. 7500 rows of data in 4 columns is updated but not all rows have changed since the last update.I found the following code in the group that worked fine when I manually enter a number in the forth column but when the web q... 20 Jul 2008 02:16