Mixing
Updating row of a table using VBA [closed]
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have a table like this.
I need to edit this using VBA userform.
I need select a serial no from a list, and other details should be comes to text at the change event.
So I made up the following userform.
And I added rowSource of serial no list box as serial no. How I should view the toytype, wheel and nale to the text boxes.Appreciate a guidance from you.
excel vba excel-vba
asked Jan 3 at 2:18
h pavih pavi
104
closed as too broad by Scott Holtzman, BigBen, Storax, Siddharth Rout, TylerH Jan 3 at 18:55
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
I have a table like this.
I need to edit this using VBA userform.
I need select a serial no from a list, and other details should be comes to text at the change event.
So I made up the following userform.
And I added rowSource of serial no list box as serial no. How I should view the toytype, wheel and nale to the text boxes.Appreciate a guidance from you.
excel vba excel-vba
asked Jan 3 at 2:18
h pavih pavi
104
closed as too broad by Scott Holtzman, BigBen, Storax, Siddharth Rout, TylerH Jan 3 at 18:55
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
I don't download files from the Internet.
– Variatus
Jan 3 at 3:33
@Variatus You download files every time you go to a website. Maybe you just don't realize it.
– TylerH
Jan 3 at 18:55
add a comment |
I have a table like this.
I need to edit this using VBA userform.
I need select a serial no from a list, and other details should be comes to text at the change event.
So I made up the following userform.
And I added rowSource of serial no list box as serial no. How I should view the toytype, wheel and nale to the text boxes.Appreciate a guidance from you.
excel vba excel-vba
asked Jan 3 at 2:18
h pavih pavi
104
I have a table like this.
I need to edit this using VBA userform.
I need select a serial no from a list, and other details should be comes to text at the change event.
So I made up the following userform.
And I added rowSource of serial no list box as serial no. How I should view the toytype, wheel and nale to the text boxes.Appreciate a guidance from you.
excel vba excel-vba
excel vba excel-vba
asked Jan 3 at 2:18
h pavih pavi
104
asked Jan 3 at 2:18
h pavih pavi
104
edited Jan 9 at 2:08
h pavi
asked Jan 3 at 2:18
h pavih pavi
104
asked Jan 3 at 2:18
h pavih pavi
104
asked Jan 3 at 2:18
h pavih pavi
104
104
closed as too broad by Scott Holtzman, BigBen, Storax, Siddharth Rout, TylerH Jan 3 at 18:55
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
closed as too broad by Scott Holtzman, BigBen, Storax, Siddharth Rout, TylerH Jan 3 at 18:55
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
I don't download files from the Internet.
– Variatus
Jan 3 at 3:33
@Variatus You download files every time you go to a website. Maybe you just don't realize it.
– TylerH
Jan 3 at 18:55
add a comment |
I don't download files from the Internet.
– Variatus
Jan 3 at 3:33
@Variatus You download files every time you go to a website. Maybe you just don't realize it.
– TylerH
Jan 3 at 18:55
I don't download files from the Internet.
– Variatus
Jan 3 at 3:33
I don't download files from the Internet.
– Variatus
Jan 3 at 3:33
@Variatus You download files every time you go to a website. Maybe you just don't realize it.
– TylerH
Jan 3 at 18:55
@Variatus You download files every time you go to a website. Maybe you just don't realize it.
– TylerH
Jan 3 at 18:55
add a comment |
1 Answer
1
active
oldest
votes
Once no code was provided I'll only do a general explanation.
(Check this link for future questions)
First, if you really want to select you need to use a ComboBox and before you Load/Show the form use the following code:
myArray = ws.Range() 'Define your serial no. range here
With Me.ComboBox
.List = myArray
End With
To update other fields when a value is selected, use a sub like this on the userform:
Private Sub myCombo_AfterUpdate()
'look for Me.myCombo.Value on range and update your textbox
End Sub
answered Jan 3 at 12:25
Random_dudeRandom_dude
637
I still want to get view the sscific row of a table only based on the combo box value
– h pavi
Jan 3 at 18:51
Inside the SubmyCombo_AfterUpdate()you can do something likeApplication.Match(Me.myCombo.Value, ws.Range("A:A"), 0)
– Random_dude
Jan 4 at 10:36
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Once no code was provided I'll only do a general explanation.
(Check this link for future questions)
First, if you really want to select you need to use a ComboBox and before you Load/Show the form use the following code:
myArray = ws.Range() 'Define your serial no. range here
With Me.ComboBox
.List = myArray
End With
To update other fields when a value is selected, use a sub like this on the userform:
Private Sub myCombo_AfterUpdate()
'look for Me.myCombo.Value on range and update your textbox
End Sub
answered Jan 3 at 12:25
Random_dudeRandom_dude
637
I still want to get view the sscific row of a table only based on the combo box value
– h pavi
Jan 3 at 18:51
Inside the SubmyCombo_AfterUpdate()you can do something likeApplication.Match(Me.myCombo.Value, ws.Range("A:A"), 0)
– Random_dude
Jan 4 at 10:36
add a comment |
Once no code was provided I'll only do a general explanation.
(Check this link for future questions)
First, if you really want to select you need to use a ComboBox and before you Load/Show the form use the following code:
myArray = ws.Range() 'Define your serial no. range here
With Me.ComboBox
.List = myArray
End With
To update other fields when a value is selected, use a sub like this on the userform:
Private Sub myCombo_AfterUpdate()
'look for Me.myCombo.Value on range and update your textbox
End Sub
answered Jan 3 at 12:25
Random_dudeRandom_dude
637
I still want to get view the sscific row of a table only based on the combo box value
– h pavi
Jan 3 at 18:51
Inside the SubmyCombo_AfterUpdate()you can do something likeApplication.Match(Me.myCombo.Value, ws.Range("A:A"), 0)
– Random_dude
Jan 4 at 10:36
add a comment |
Once no code was provided I'll only do a general explanation.
(Check this link for future questions)
First, if you really want to select you need to use a ComboBox and before you Load/Show the form use the following code:
myArray = ws.Range() 'Define your serial no. range here
With Me.ComboBox
.List = myArray
End With
To update other fields when a value is selected, use a sub like this on the userform:
Private Sub myCombo_AfterUpdate()
'look for Me.myCombo.Value on range and update your textbox
End Sub
answered Jan 3 at 12:25
Random_dudeRandom_dude
637
Once no code was provided I'll only do a general explanation.
(Check this link for future questions)
First, if you really want to select you need to use a ComboBox and before you Load/Show the form use the following code:
myArray = ws.Range() 'Define your serial no. range here
With Me.ComboBox
.List = myArray
End With
To update other fields when a value is selected, use a sub like this on the userform:
Private Sub myCombo_AfterUpdate()
'look for Me.myCombo.Value on range and update your textbox
End Sub
answered Jan 3 at 12:25
Random_dudeRandom_dude
637
answered Jan 3 at 12:25
Random_dudeRandom_dude
637
answered Jan 3 at 12:25
Random_dudeRandom_dude
637
answered Jan 3 at 12:25
Random_dudeRandom_dude
637
637
I still want to get view the sscific row of a table only based on the combo box value
– h pavi
Jan 3 at 18:51
Inside the SubmyCombo_AfterUpdate()you can do something likeApplication.Match(Me.myCombo.Value, ws.Range("A:A"), 0)
– Random_dude
Jan 4 at 10:36
add a comment |
I still want to get view the sscific row of a table only based on the combo box value
– h pavi
Jan 3 at 18:51
Inside the SubmyCombo_AfterUpdate()you can do something likeApplication.Match(Me.myCombo.Value, ws.Range("A:A"), 0)
– Random_dude
Jan 4 at 10:36
I still want to get view the sscific row of a table only based on the combo box value
– h pavi
Jan 3 at 18:51
I still want to get view the sscific row of a table only based on the combo box value
– h pavi
Jan 3 at 18:51
Inside the Sub
myCombo_AfterUpdate() you can do something like Application.Match(Me.myCombo.Value, ws.Range("A:A"), 0)– Random_dude
Jan 4 at 10:36
Inside the Sub
myCombo_AfterUpdate() you can do something like Application.Match(Me.myCombo.Value, ws.Range("A:A"), 0)– Random_dude
Jan 4 at 10:36
add a comment |
I don't download files from the Internet.
– Variatus
Jan 3 at 3:33
@Variatus You download files every time you go to a website. Maybe you just don't realize it.
– TylerH
Jan 3 at 18:55