Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Visual Basic simple Question

Posted on 2004-04-12
Last Modified: 2013-11-25
I have a question that has frustrated me while doing my homework. We do not get grades on it. I am 58 and taking it as a 'recreational' subject with the intention to know as much as possible.

I have a txtBox where one enters a Number. I then have a Summary Box which supposed to take the contents of the box and plases it on command into a lbl box. The intention is to accumulate numbers in the Summary box. For some reason it does not work. I can accumulate numbers from a lblbox to a lbl Box but from a txt Box to a lable summary box results in a blank entry.

The 'Sales' commands work as shown below:

Dim curWeeklySales As Currency
Dim SummaryWeeklySales1 As Currency
curWeeklySales = Val(txtWeeklySales)
lblSummaryWeeklySales1.Caption = FormatNumber(curWeeklySales) _
+ Val(lblSummaryWeeklySales1.Caption)

The following where out of frustration gave the cammand a number, resulted in a blank.

Dim curSummaryWeeklyPay1 As Currency
  lblSummaryWeeklyPay1.Caption = 10000 This results in a blank
 lblSummaryWeeklyPay1.Caption = Val(LblPay1.Caption) This also results in a blank


Question by:gonzal13
LVL 11

Expert Comment

ID: 10810199
>>Dim curSummaryWeeklyPay1 As Currency
    lblSummaryWeeklyPay1.Caption = 10000 This results in a blank
    lblSummaryWeeklyPay1.Caption = Val(LblPay1.Caption) This also results in a blank

This works ok for me, are you sure the label names are correct?

Also where is LblPay1.Caption getting its value from? If its blank then lblSummaryWeeklyPay1 will be blank.

Can you post your whole code? i.e. Everything under the button click?
LVL 13

Author Comment

ID: 10810351
Please note that the last line of code istxt instead of lbl

   lblSummaryWeeklyPay1.Caption = Val(LblPay1.Caption) This also results in a blank

The above is the complete code for this mnu command

In frustration to see what would happen I forced lblSummaryWeeklyPay1.caption to = 10000


Oh, since Microsoft introduced VB.net, the VB6 books can be had at 20 percent of their value on Amazon and half.com
LVL 19

Expert Comment

ID: 10810849
Try this:

lblSummaryWeeklyPay1.Caption = Val(LblPay1.text) This also results in a blank

I know that doesnt make much sense because you have it defined as lblPay1.

But you said "Please note that the last line of code istxt instead of lbl"
I am assuming that you mean its a text box and not a label.

So to get text from a text box you can either do, Text1 or Text1.text.

Good Luck
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

LVL 19

Accepted Solution

BrianGEFF719 earned 50 total points
ID: 10810850
lblSummaryWeeklyPay1.Caption = Val(LblPay1.text)
LVL 19

Expert Comment

ID: 10810851
lblSummaryWeeklyPay1.Caption = Val(LblPay1.text)
LVL 13

Author Comment

ID: 10815310

I shall take your notes to the professor today (Tuesday)

my final version that does not work is
lblSummaryWeeklyPay1.Caption = Val(txtPay1.text)

Expert Comment

ID: 10817891
lblSummaryWeeklyPay1.Caption = Val(txtPay1.text)

This should work, even if txtPay1.text is blank, the label would come out as zero.

Just a suggestion, have you made the Label forecolor the same as the backcolor? For example printing blue characters on a blue background.  Or have you made the label too small or too big, and the characters are falling of the form?

May I suggest you put some text into the caption properties at design time, just to prove you can see it.


Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Hide vba in gp 7 104
Interview questions for support of a legacy ASP.NET site 4 69
PL SQL Developer 7 52
how to loop through and process two columns in excel 8 13
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question