Hello, all.
I am new to VBA and have a simple question.
How to change line in VBA
The code looks like this:
Private Sub SLICC_MALIGNANCY_AfterUpdate()
Me!TOTALSCORE = Me!item1+Me!item2+......+Me!item200
End Sub
I want to add up many values. But they are too long to be shown in one line. How can I change line while maintain the statement
Thank you vary much!
Qian
How to change line within one statement?
Hot Topic
- Sorry it may not have been clear as>>
- Size Form to fit user resolution
- Can you use VBA to access a spread sheet embedded in a word doc?
- Highlight Row depending on cell - Excel VBA -
- using dll file
- Cell Equal To EXACT Value
- How to stop a never ending loop
- Configuration Failed: Windows SharePoint Services 3.0 (Beta)
- Check if an Excel workbook is opened and in use by somebody else
- Change format of cells
Microsoft ISV
- Using arrows to select in drop down list in access
- Help to create a new table using VBA codes
- How to populate a list box using adodb recordset
- Error 3251 using ADO & VBA to drop a table!
- How to convert excel file to .DAT file?
- Help with Excel VBA Code
- VBA sheet using registered dll functions across a network
- what OS are included in MSDN OS subscription?
- Unable to start debugging In VS2005
- Windows Authentication for custom built application
How to change line within one statement?
yromanen
If you need to "split" a line of VBA code, type a space after one of the
plus signs, then type an underscore, then press Enter. like this:
Me!TOTALSCORE = Me!item1+Me!item2+ _
+Me!item200
TaiChiMaster
Hi Qian,
Try using the Eval() function, example....
Private Sub SLICC_MALIGNANCY_AfterUpdate()
Dim TotalScore as Integer
For n = 1 to 200
TotalScore = TotalScore + Eval("Me!item" & n)Next
M
e!TOTALSCORE = TotalScoreEnd Sub
Boulderdude
Hello Qian,
Are you using Excel,
Where are you getting Me!Item1, is it a cell reference ; in which case how about the SUM function.
Post some more information and I'm sure there is a way.
Chas
r3n
Thank you very much for your reply! Actually I want to know how to break the limit of the length of one line in VBA.
I am using MS Access. Me!item is the name of my fields. :)
Now I know how to do it. Thank you all!
Qian