Add Item in list box inside chart sheet using vba

I have written macro for adding elements inside form control listbox using vba on chart sheet but after writting following code
elements are successfully added inside simple worksheet but not added inside chart sheet

Sub showChartDataList()

 Set o = ActiveSheet.Shapes("List Box 2")

 o.ControlFormat.RemoveAllItems

 o.ControlFormat.AddItem 1

 o.ControlFormat.AddItem 2

 o.ControlFormat.AddItem 4

 o.ControlFormat.AddItem 5

 o.ControlFormat.AddItem 1

 o.ControlFormat.AddItem 2

 o.ControlFormat.AddItem 4

 o.ControlFormat.AddItem 5

 o.ControlFormat.AddItem 1

 o.ControlFormat.AddItem 2

 o.ControlFormat.AddItem 4

 o.ControlFormat.AddItem 5

 o.ControlFormat.AddItem 1

 o.ControlFormat.AddItem 2

 o.ControlFormat.AddItem 4

 o.ControlFormat.AddItem 5

 End Sub
Excel Sheet listBox (successfully Added)
chart sheet listbox (Elements not Added)

Comments

Post a Comment

Popular posts from this blog

Secure Database Connectivity in node.js with mysql

Image
Hi Everyone! Yesterday my friend Andrea from Italy asked me a question about secure Database connectivity in node.js with mysql i.e. he wants to a secure database connection in node.js for some secure keys like username,password,database name that we use during database connectivity.His problem is obviously right from security point of view as we know that JavaScript is client side scripting knowledge so it is compiled on client side so after inspecting page some one can be able to view these secure keys which I discussed previously. I surf internet and found there are various ways to solve this problem I am not discussing all of them here but also I discussing here two of them and after this discussion I think Andrea and other reader who are facing with same problem can be able to resolve their problem. I choose two ways to solve this problem. Connection code in app.js file Create a Json file Connection code in app.js file : Javascript is client side language and code i
Keep reading

Export data from mysql db to csv file using java

Image
Hi friends ! Today I am discussing about simple but very important scenario. When we create any application then during creation of application we have face many scenarios like 1.Taking information from user and storing these information inside database : Generally such type of Operation is performed by user using form application 2.Taking Data from Database and Displaying on Page : We can perform such type of Operation in various ways like using JSP,JSTL tags or you can perform such operations using JQUERY also. 3.Taking Data from Database and download it in Excel or CSV format : In this we want our data from database and store it inside Excel or text files for further use. And we have chosen third scenario from discussion for performing this Operation we have to need three files exportCsv.html  :- this contains a button for clicking and performing exporting data from database Operation ExportData.java  :- It is a servlet class which defines connectivity from databas
Keep reading

API (Application Programming Interface)

Image
Definition  1.A set of routines by which an application program can call specific programs or services of a computer operating system (OS) or network operating system (NOS). 2.A set of routines by which an application program allows another application program to work directly with it.            ( A pplication P rogramming I nterface) A language and message format used by an application program to communicate with the operating system or some other control program such as a database management system (DBMS) or communications protocol. APIs are implemented by writing function calls in the program, which provide the linkage to the required subroutine for execution. Thus, an API implies that a driver or program module is available in the computer to perform the operation or that software must be linked into the existing program to perform the tasks. Plenty of API Programming Is Done Understanding an API is a major part of what a programmer does. Except for
Keep reading