Click here to Skip to main content
15,900,973 members
Home / Discussions / Visual Basic
   

Visual Basic

 
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 
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 
IC. You would then pass an array of strings to the values collection, e.g.
ActiveChart.SeriesCollection(index).Values = Array(Range("Sheet1!$A$29"), Range("Sheet1!$B$33"), Range("Sheet1!$C$35"), Range("Sheet1!$C$30"))
But this you only need if your Ranges are spread over your sheet.
If you follow Daves advice and order them blockwise (in a hidden sheet), you can simply add the resulting (ordered) range like e.g.
ActiveChart.SeriesCollection.Add Source:=Range(Worksheets("Sheet1").Range("C5:T5"))

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 
GeneralRe: Tab Order with UserControls Pin
Andrew Holland11-Jun-09 6:25
Andrew Holland11-Jun-09 6:25 
AnswerRe: Tab Order with UserControls Pin
Andrew Holland27-Aug-09 6:00
Andrew Holland27-Aug-09 6:00 
QuestionForm size issues.. Pin
No-e10-Jun-09 10:07
No-e10-Jun-09 10:07 
AnswerRe: Form size issues.. Pin
Christian Graus10-Jun-09 10:33
protectorChristian Graus10-Jun-09 10:33 

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.