Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 69
Default Adding two values

Hi Greg,

Just pass the value of the label to a variable and then add that to the
activecell see code below. I think the problem you were having is that
a caption is a string not a value.

Dim ans
Dim lbl2 as interger

On Error Resume Next


ans = Application.Match(CLng(Label1.Caption), Range("A:A"), 0)
If Not IsError(ans) Then
lbl2 = cint(Label2.Caption)
Application.Index(Range("B:B"), ans) = lbl2 + ActiveCell.Value


Else
MsgBox "Invalid code"
End If
On Error GoTo 0

This is untested code. Cint converts the caption to an interger.

Any problems then post back.

James

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding mm:ss values Howard Kaikow Excel Worksheet Functions 10 August 13th 09 05:21 PM
Adding Values Sandy Excel Worksheet Functions 3 May 4th 08 04:39 PM
Adding numerical values based on multiple values in another column Kazmaniac Excel Worksheet Functions 6 April 4th 07 08:53 PM
adding name values AKPhil Excel Worksheet Functions 7 April 27th 06 01:21 AM
adding name values AKPhil Excel Discussion (Misc queries) 1 April 26th 06 09:41 PM


All times are GMT +1. The time now is 09:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"