Click here to Skip to main content
15,921,990 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: How to handle Listview mouse events? Pin
Chaitanya kumar CVSS19-Aug-08 1:47
Chaitanya kumar CVSS19-Aug-08 1:47 
QuestionMasked TextBox Direction Pin
emadmilan18-Aug-08 7:00
emadmilan18-Aug-08 7:00 
AnswerRe: Masked TextBox Direction Pin
Jon_Boy18-Aug-08 7:13
Jon_Boy18-Aug-08 7:13 
GeneralRe: Masked TextBox Direction Pin
emadmilan18-Aug-08 9:18
emadmilan18-Aug-08 9:18 
GeneralRe: Masked TextBox Direction Pin
Jon_Boy19-Aug-08 1:47
Jon_Boy19-Aug-08 1:47 
QuestionOdd problem - macros are not working at all... Pin
Jon_Boy18-Aug-08 5:55
Jon_Boy18-Aug-08 5:55 
AnswerRe: Odd problem - macros are not working at all... Pin
Jon_Boy19-Aug-08 3:32
Jon_Boy19-Aug-08 3:32 
Questionmerging cells to perform calculations in escel visual basic Pin
Matthew Leggett18-Aug-08 5:34
Matthew Leggett18-Aug-08 5:34 
Hi
I have the following script

Dim DStartR As String
Dim DStartC As String
Dim DEndR As String
Dim DEndC As String
Dim StartLocation As String
Dim EndLocation As String

Worksheets(SetMonth).Range("D5").Select
DStartR = "=Cell(""row"",RC)" 'ROW ADDRESS OF D5
DStartC = "=Cell(""row"",R[-1]C)" 'COLUMN ADDRESS OF D5

Worksheets(SetMonth).Range("E5").Select
DEndR = "=Cell(""row"",RC)" 'ROW ADDRESS OF
DEndC = "=Cell(""row"",R[-1]C)"

How do I combine the variables DStartR and DStartC to give me a variable called StartLocation and variables DEndR and DEndC to give me a variable called EndLocation

I then need to generate a calculation using these points which will update as their contents change.

I was using a For LOOP to generate a Variable called DTOTAL, however once the script had finished, it wouldn't update when D5/E5 changed, as a result I need to generate a sum at a location that could potential change based on various generated information.

ie run1 of the script could put DTOTAL at cell reference A22, however run2 of the script could put DTOTAL at cell reference A23 etc.

as a result I need to use the following line of code I think

ActiveCell.Value = "=sum(" & StartLocation &":" & EndLocation &)"

I am unable to check the above as I cant' figure out how to generate StartLocation and EndLocation

I am going to carry on trying to figure out how to do what I need to do, however if some1 can give me a heads up, it would be appreciated

Thanks In Advance
QuestionLimit choices that can be provided to a method argument Pin
Marcus J. Smith18-Aug-08 4:29
professionalMarcus J. Smith18-Aug-08 4:29 
AnswerRe: Limit choices that can be provided to a method argument Pin
Steven St. John18-Aug-08 5:12
Steven St. John18-Aug-08 5:12 
AnswerRe: Limit choices that can be provided to a method argument Pin
Jon_Boy18-Aug-08 5:27
Jon_Boy18-Aug-08 5:27 
QuestionHow to update the values in table using sql bulk copy Pin
member2718-Aug-08 3:03
member2718-Aug-08 3:03 
AnswerRe: How to update the values in table using sql bulk copy Pin
Mycroft Holmes18-Aug-08 12:38
professionalMycroft Holmes18-Aug-08 12:38 
QuestionIcon for a new control (vb.net 2008) Pin
JR21218-Aug-08 2:33
JR21218-Aug-08 2:33 
AnswerRe: Icon for a new control (vb.net 2008) Pin
John_Adams18-Aug-08 3:50
John_Adams18-Aug-08 3:50 
GeneralRe: Icon for a new control (vb.net 2008) Pin
JR21219-Aug-08 7:40
JR21219-Aug-08 7:40 
QuestionRe: Icon for a new control (vb.net 2008) Pin
JR21219-Aug-08 23:40
JR21219-Aug-08 23:40 
QuestionDeploying font in setup files Pin
helelark12318-Aug-08 2:15
helelark12318-Aug-08 2:15 
AnswerRe: Deploying font in setup files Pin
Thomas Stockwell18-Aug-08 5:39
professionalThomas Stockwell18-Aug-08 5:39 
AnswerRe: Deploying font in setup files Pin
Manas Bhardwaj18-Aug-08 5:58
professionalManas Bhardwaj18-Aug-08 5:58 
Question[SOLVED!!!] Trying to draw custom form bitmap Pin
The Cadde18-Aug-08 0:21
The Cadde18-Aug-08 0:21 
Questionrow click event in datagridview Pin
Milind Panchal17-Aug-08 23:26
Milind Panchal17-Aug-08 23:26 
Questionhi how this string is splited and how to eliminate special characters Pin
lakshmichawala17-Aug-08 19:59
lakshmichawala17-Aug-08 19:59 
AnswerRe: hi how this string is splited and how to eliminate special characters Pin
Christian Graus17-Aug-08 21:55
protectorChristian Graus17-Aug-08 21:55 
AnswerRe: hi how this string is splited and how to eliminate special characters Pin
Noctris17-Aug-08 21:57
Noctris17-Aug-08 21:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.