Spreadsheet control in visual basic 2010 express edition

Question

I want to insert a spreadsheet on my form. I can't find any spreadsheet controls already installed and cannot find and excel or spreadsheet controls to add in. Plz help, I just want to create a spreadsheet on the form.

Answer 1

Hi Davies-2149,

Welcome to the MSDN forum.

I’m afraid that there is no spreadsheet control like Excel in general VB.Net application. If you want to display the data as table, I will suggest you to use the DataGridView Control. Here is the information about this control: http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.aspx

If you insist to using the spreadsheet control like Excel, I’m afraid that you need to custom this control. Here is a sample about Creating Your First User Control: http://msdn.microsoft.com/en-us/library/ttb1w24s(v=vs.90).aspx

If I misunderstood or you have any additional question, please feel free to let me know.

---

Mark Liu-lxf [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi Davies-2149,

We haven’t heard from you for several days. I’d like to mark my reply as answer firstly. If you have any additional questions, you also can unmark the replay and post your question here. 

Sorry for any inconvenience and have a nice day.

---

Mark Liu-lxf [MSFT]
MSDN Community Support | Feedback to us

Answer 3

Hi,

did you now how i can create some cells or a pair of text boxes that i can move into them with the TAB Keystroke like a spreadsheet on exel?

Thanks!