Nathan_Barratt
New Member
- Joined
- Nov 28, 2017
- Messages
- 14
Good Afternoon all,
Although not an absolute beginner using VBA I am somewhat of a novice. (I think its an age thing)
I am wondering if someone can assist me with the following problem as, I think with information overload, I have totally blown myself out of the water.
I have the following<o></o>
Userform Named – “Search_Edit_Weapons”<o></o>
This Userform has the followingproperties<o></o>
1. Text Box Named – “tbTeamName” (value is derivedfrom another source and works fine)<o></o>
2. Text Box Named – Weapon1<o></o>
3. Text Box Named – Weapon2<o></o>
4. Text Box Named – Weapon3<o></o>
5. Text Box Named – Weapon4<o></o>
6. Text Box Named – Weapon5<o></o>
7. Text Box Named – Weapon6<o></o>
8. Text Box Named – Weapon7<o></o>
9. Text Box Named – Weapon8<o></o>
It also has a command button named –“Save”<o></o>
A Table Named – “WeapLookup”contained in a sheet called “Weapons Data”<o></o>
1. The first column of the table is anmed “TeamName”<o></o>
2. Then the following rows beneath it named<o></o>
V1<o></o>
V2<o></o>
V3<o></o>
V4<o></o>
V5<o></o>
V6<o></o>
V7<o></o>
V8<o></o>
V9<o></o>
V10<o></o>
3. Columns 2 – 9 contain serial number databelonging to each of the above rows.<o></o>
I need the userform to <o></o>
1. automatically populate on opening based on thevalue in the textbox "tbTeamName".<o></o>
I then need to be able to<o></o>
1. Change a piece of data (if necessary) in one ofthe other text boxes<o></o>
2. Update on the click of the command button “Save”
I know it appears cheeky to ask for the code but I lost my temper and deleted everything that I had tried from other sources.
Thanks in advance
<o></o>
Although not an absolute beginner using VBA I am somewhat of a novice. (I think its an age thing)
I am wondering if someone can assist me with the following problem as, I think with information overload, I have totally blown myself out of the water.
I have the following<o></o>
Userform Named – “Search_Edit_Weapons”<o></o>
This Userform has the followingproperties<o></o>
1. Text Box Named – “tbTeamName” (value is derivedfrom another source and works fine)<o></o>
2. Text Box Named – Weapon1<o></o>
3. Text Box Named – Weapon2<o></o>
4. Text Box Named – Weapon3<o></o>
5. Text Box Named – Weapon4<o></o>
6. Text Box Named – Weapon5<o></o>
7. Text Box Named – Weapon6<o></o>
8. Text Box Named – Weapon7<o></o>
9. Text Box Named – Weapon8<o></o>
It also has a command button named –“Save”<o></o>
A Table Named – “WeapLookup”contained in a sheet called “Weapons Data”<o></o>
1. The first column of the table is anmed “TeamName”<o></o>
2. Then the following rows beneath it named<o></o>
V1<o></o>
V2<o></o>
V3<o></o>
V4<o></o>
V5<o></o>
V6<o></o>
V7<o></o>
V8<o></o>
V9<o></o>
V10<o></o>
3. Columns 2 – 9 contain serial number databelonging to each of the above rows.<o></o>
I need the userform to <o></o>
1. automatically populate on opening based on thevalue in the textbox "tbTeamName".<o></o>
I then need to be able to<o></o>
1. Change a piece of data (if necessary) in one ofthe other text boxes<o></o>
2. Update on the click of the command button “Save”
I know it appears cheeky to ask for the code but I lost my temper and deleted everything that I had tried from other sources.
Thanks in advance
<o></o>