I know this is an old thread, but I came across it and wanted to let ADezii know that his KeyCode=0 bit solved a problem for me too. Not altogether sure I know why that works, but it does what is needed. Thanks.
Annie
Annie Bender
Last Activity: Apr 26 '10, 05:39 PM
Joined: Feb 20 '10
Location: Gold Coast Florida
-
Resolved
Novice VBA mistake (I've already made a ton of those). I'm posting the solution for anyone facing a similar problem in the future who comes across this thread.
Sam was on the right track to use .Value in place of .Text, but I kept getting the "Type mismatch" error. Eventually, it was pointed out to me that my coding line was using a "+" to join two parts of the label together, rather than...Leave a comment:
-
Hi Sammy. Thanks for the response. Using .Value in place of .Text leads to a "Type Mismatch" run-time error. Anyway, the label caption will render all of the desired worksheet cell contents correctly, but only if the worksheet data column is wide enough to display it too, and that's what I don't want to have to do. The user has no interest in that data and so shouldn't even be seeing it on the worksheet. And yet, when I set the column width...Leave a comment:
-
VBA Label Caption Won't Display When Excel Column Width is 0
Wow, I finally got through my first VB "tutorial" project and everything works nice, except one userform label caption will only display as long as the Excel column it draws data from is set wide enough to show the data on the spreadsheet too. But that data is not supposed to be visible to spreadsheet users, as it involves intermediate calculations only. I don't see anything special about either that particular data (it's numeric) or about... -
Hi, Is there no way to do this?
In my search I have come across the syntax:
Pages = ExecuteExcel4Ma cro("Get.docume nt(50,""Sheet2" ")")
for getting number of pages in Sheet2, even if Sheet2 is not active. But when I try this without Sheet 2 being active (.Activate or .Select), it returns an Error 2042, something about a "type mismatch". I don't know how to cure this,...Leave a comment:
-
Avoid using Select method with worksheets in VBA macro. Help please.
Hi all
The application: VBA macro in which various Excel worksheets get printed, depending on the user's print selection via radio buttons.
The problem: As part of the macro, the print range has to be set, and the number of pages in the printed report echoed to the user, both of which depend on the relevant worksheet selected for printing. My coding for this is:
...Code:Print_Range = "A8:I" &
-
Thank you so much ggeu. Using the multipage control is so easy, and does exactly what I want. I still don't really know in what situation the tabstrip would get used, but for now, multipage has solved the problem for me. Also, it sounds like maybe I can't just download the missing OCX files and give my VBA editor the other VB6 controls, like SStab, etc. Thanks to all who offered suggestions. Annie's happy again.Leave a comment:
-
TabStrip vs. SSTab Control
Thank you guys for your comments. I think part of the problem I am having is that I must have a "lite" version of VB6 (it's not stand alone, but only launches thru Excel, AFAIK) and it's missing some of the OCX files, including tabctl32.ocx and maybe some other ActiveX controls too. So, I don't have the SSTab control in my Toolbox. So a couple of other questions for the smart guys out there:...Leave a comment:
-
Hi vb5prgrmr, I've tried your suggestions repeatedly without success. Selecting the tabstrip control and then pasting an existing frame on it or creating a new frame from the toolbox, either way, it doesn't get associated with one of the specific tabs on the tabstrip control. Maybe I should rephrase my original question:
Is there a way to associate frame (and other) controls with a specific tab on the tabstrip at design time, or does...Leave a comment:
-
Thanks for taking the time to reply and include screen shots, but that doesn't do what I asked about. I need to find out how to launch the tab collection editor (I guess) or some other interface that lets me associate content with a particular tab on the tab strip at design time. I don't see that even in the screen shots you posted, and it certainly isn't on my properties box for the tab strip control.Leave a comment:
-
Associating content to tabs via Tab Strip Control
Hi all, I'm making progress in the VBA learning curve, but need your help again. Application is a simple user form containing static info in several frames. No dynamic content to worry about at run time.
Problem: Associating specific content with specific tabs on a tab strip control at design time. Seems like that should be a slam dunk, but all I can find in searches is lots of coding for dynamically changing/adding tabs programmaticall y.... -
Thank you. I'm embarassed. I usually do a search before resorting to posting a question, but I obviously missed it this time or I would have found the FORMAT function easily. It works nicely. Thanks vb5prgrmr.
AnnieLeave a comment:
-
VB Formatting Question for Excel Application
Hi again everyone. Is there a standard formatting function available in VB to insert the 1000 comma separator in a calculated numeric result? In Excel, the same can be achieved using the standard function =TEXT(123456,"0 00\,000") to produce 123,456. If not, what would you suggest as coding for a customized function or sub? The formatted result does not get used in further calculations. Thanks as always for helping out a newbie.
... -
Thank you Stewart. I tried so many things, I must have tried that at some time, without success. Anyway, it works, but only if I include the form name as the first object, and the statement needs to precede the UserForm1.Show statement. That makes sense, I guess.
UserForm1.Label 1.Caption = Worksheets("You rSheetName").Ra nge("A1")
Now, it's on to the next hurdle in the learning curve. I'm sure I'll...Leave a comment:
-
Changing a Label Caption at runtime from a data source
Hi guys, brand new here as you can see. Brand new to VB too, although pretty good at HTML, asp, VBScript, Java script.
This will seem simple to you guys, but I am stuck here! The intended application is the simple user box displayed in an Excel workbook, shown in the thumbnail below. It's all static content, nothing interactive, and I've got it put together except for one thing: I want the main text in the box to contain a volatile...
No activity results to display
Leave a comment: