[TABLE="class: grid, width: 800, align: center"]
<tbody>[TR]
[TD="align: center"]Team1[/TD]
[TD="align: center"]Team2[/TD]
[TD="align: center"]Team1Run[/TD]
[TD="align: center"]Team1Over[/TD]
[TD="align: center"]Team2Run[/TD]
[TD="align: center"]Team2Over[/TD]
[TD="align: center"]Tie?[/TD]
[TD="align: center"]NR?[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have this form to be filled by a VBA form. I followed many VBA Form codes but unable to correctly enter data into the form. This form is located in sheet MatchData starting cell A1.
I have a form as appeared in the image below link. I am not able to upload the image directly.
All the form control names are same as the table heading.
Team1 and Team2 are comboboxes and record source is a named range OnlyTeams.
Team1Run and Team2Run are text boxes and accepts positive integers.
Team1Over and Team2Over are text boxes and accepts positive decimal numbers.
All buttons are prefixed by btn. For example, btnClear, btnClose. Plase disregard the Save button.
The help will be highly appreciated.
<tbody>[TR]
[TD="align: center"]Team1[/TD]
[TD="align: center"]Team2[/TD]
[TD="align: center"]Team1Run[/TD]
[TD="align: center"]Team1Over[/TD]
[TD="align: center"]Team2Run[/TD]
[TD="align: center"]Team2Over[/TD]
[TD="align: center"]Tie?[/TD]
[TD="align: center"]NR?[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have this form to be filled by a VBA form. I followed many VBA Form codes but unable to correctly enter data into the form. This form is located in sheet MatchData starting cell A1.
I have a form as appeared in the image below link. I am not able to upload the image directly.
All the form control names are same as the table heading.
Team1 and Team2 are comboboxes and record source is a named range OnlyTeams.
Team1Run and Team2Run are text boxes and accepts positive integers.
Team1Over and Team2Over are text boxes and accepts positive decimal numbers.
All buttons are prefixed by btn. For example, btnClear, btnClose. Plase disregard the Save button.
The help will be highly appreciated.
Last edited: