Click here to Skip to main content
15,881,204 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: ARW Thumbnails with VB.Net Pin
Dave Kreskowiak12-Jun-09 3:33
mveDave Kreskowiak12-Jun-09 3:33 
QuestionVB6 to .net upgrade issue [modified] Pin
No-e11-Jun-09 7:49
No-e11-Jun-09 7:49 
AnswerRe: VB6 to .net upgrade issue Pin
Dave Kreskowiak11-Jun-09 9:10
mveDave Kreskowiak11-Jun-09 9:10 
GeneralRe: VB6 to .net upgrade issue Pin
No-e11-Jun-09 10:50
No-e11-Jun-09 10:50 
QuestionFiltering the results of GetDirectories? Pin
Sonhospa11-Jun-09 7:32
Sonhospa11-Jun-09 7:32 
AnswerRe: Filtering the results of GetDirectories? Pin
Luc Pattyn11-Jun-09 9:00
sitebuilderLuc Pattyn11-Jun-09 9:00 
NewsRe: Filtering the results of GetDirectories? Pin
Sonhospa11-Jun-09 10:10
Sonhospa11-Jun-09 10:10 
QuestionVBA (Bar chart error: String too long) Pin
jainga1021311-Jun-09 6:57
jainga1021311-Jun-09 6:57 
I want to plot a number of different cells from a sheet in to a bar chart. The cells may lie anywhere in the sheet (not necessarily in one row or column).
I have an array that stores the address of these cells.

This is what I am doing to plot the bar chart in VBA

Firstly, I make a string of the cell addresses (for eg DataSheet!$B$4, DataSheet!$B$3, DataSheet!$E$7, DataSheet!$G$11, DataSheet!$J$1)

Then pass this string to the chart for plotting

ActiveChart.SeriesCollection.Add Source:=Range(Str)

This works fine till the number of data points are less. But when the datapoints are large, the string grows bigger in size and the above plot function fails.

Is there nay other way I can accomplish this?

Thanks,
GJ
AnswerRe: VBA (Bar chart error: String too long) Pin
Luc Pattyn11-Jun-09 7:36
sitebuilderLuc Pattyn11-Jun-09 7:36 
AnswerRe: VBA (Bar chart error: String too long) Pin
Sonhospa11-Jun-09 8:17
Sonhospa11-Jun-09 8:17 
GeneralRe: VBA (Bar chart error: String too long) Pin
jainga1021311-Jun-09 8:28
jainga1021311-Jun-09 8:28 
AnswerRe: VBA (Bar chart error: String too long) Pin
Sonhospa11-Jun-09 9:48
Sonhospa11-Jun-09 9:48 
AnswerRe: VBA (Bar chart error: String too long) Pin
Dave Kreskowiak11-Jun-09 9:07
mveDave Kreskowiak11-Jun-09 9:07 
Questionis possible GET data from web page Pin
sal2111-Jun-09 5:08
sal2111-Jun-09 5:08 
AnswerRe: is possible GET data from web page Pin
Colin Angus Mackay11-Jun-09 5:50
Colin Angus Mackay11-Jun-09 5:50 
QuestionVB6 sendkey is not working under window vista Pin
Member 367682211-Jun-09 1:38
Member 367682211-Jun-09 1:38 
AnswerRe: VB6 sendkey is not working under window vista Pin
Henry Minute11-Jun-09 2:10
Henry Minute11-Jun-09 2:10 
AnswerRe: VB6 sendkey is not working under window vista Pin
Nagy Vilmos11-Jun-09 2:54
professionalNagy Vilmos11-Jun-09 2:54 
AnswerRe: VB6 sendkey is not working under window vista Pin
Dave Kreskowiak11-Jun-09 3:40
mveDave Kreskowiak11-Jun-09 3:40 
Questiondynamic call of a function Pin
mehrdadc4811-Jun-09 1:22
mehrdadc4811-Jun-09 1:22 
AnswerRe: dynamic call of a function Pin
Dave Kreskowiak11-Jun-09 3:33
mveDave Kreskowiak11-Jun-09 3:33 
Questionbinding navigater add new Pin
nikhil123410-Jun-09 20:37
nikhil123410-Jun-09 20:37 
AnswerRe: binding navigater add new Pin
Nagy Vilmos11-Jun-09 0:16
professionalNagy Vilmos11-Jun-09 0:16 
QuestionTab Order with UserControls Pin
Andrew Holland10-Jun-09 10:11
Andrew Holland10-Jun-09 10:11 
AnswerRe: Tab Order with UserControls Pin
Johan Hakkesteegt11-Jun-09 0:27
Johan Hakkesteegt11-Jun-09 0:27 

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.