Stargazer
12-07-2010, 07:23 AM
Hiya,
I'm trying to build one of my Excel VBA projects into a VB.net executable and have stumbled into a problem. Namely, I need a data grid capable of referencing and updating itself much like Excel spreadsheets do but it must be completely self contained within a Userform application.
I know that VBA and VB.Net are two very different animals. But I'm hoping there enough common between them for some advice.
Why don't I go ask at a VB.Net forum?
Well... I don't really see the point in signing up to a forum only to ask one question and never return. You'll see from my post count here at VBAX that I havn't posted a bunch of times, and it's not that I don't want to get involved, it's just that everyone else is way smarter than me and can answer more reliably. But people here are clever and willing to share and I thought of VBAX when I got stuck.
What I've tried so far is creating a group (grpDynamicAlpha) of textboxes. These are named Textbox1, Textbox2, etc.
I then have another group (grpFixedAlpha) of textboxes. These ones are named txtFP1, txtFP2, et.
The idea is that I create a Step Through that can step through all of the text boxes and compare them to the other set.
I've been able to say for each control in group grpDynamicAlpha, change the textbox value to "whatever", but what I'm really wanting to do is to say, for the mid value of the input text, find the letter in the Fixed group and get a text box number, and then find the equivalent textbox in the Dynamic group and output that letter to my output textbox.
Voila... Encoded text. The excel version works like a dream. Doing it in textboxes is a little harder.
Any of you guys fancy hazarding a guess?
Any help would be greatly appreciated,
Rob.
I'm trying to build one of my Excel VBA projects into a VB.net executable and have stumbled into a problem. Namely, I need a data grid capable of referencing and updating itself much like Excel spreadsheets do but it must be completely self contained within a Userform application.
I know that VBA and VB.Net are two very different animals. But I'm hoping there enough common between them for some advice.
Why don't I go ask at a VB.Net forum?
Well... I don't really see the point in signing up to a forum only to ask one question and never return. You'll see from my post count here at VBAX that I havn't posted a bunch of times, and it's not that I don't want to get involved, it's just that everyone else is way smarter than me and can answer more reliably. But people here are clever and willing to share and I thought of VBAX when I got stuck.
What I've tried so far is creating a group (grpDynamicAlpha) of textboxes. These are named Textbox1, Textbox2, etc.
I then have another group (grpFixedAlpha) of textboxes. These ones are named txtFP1, txtFP2, et.
The idea is that I create a Step Through that can step through all of the text boxes and compare them to the other set.
I've been able to say for each control in group grpDynamicAlpha, change the textbox value to "whatever", but what I'm really wanting to do is to say, for the mid value of the input text, find the letter in the Fixed group and get a text box number, and then find the equivalent textbox in the Dynamic group and output that letter to my output textbox.
Voila... Encoded text. The excel version works like a dream. Doing it in textboxes is a little harder.
Any of you guys fancy hazarding a guess?
Any help would be greatly appreciated,
Rob.