Re: OptionButton bei Start aktivieren



On 16 Apr., 13:06, Thomas Vollkommer
<ThomasVollkom...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hallo liebe NG,
in einem Tabellenblatt sind mehrere OptionButton in einer Gruppe
zusammengefasst. Wie kann ich festlegen (Excel 2002), dass bei Programmstart
der OptionButton1 aktiv ist?
Vielen Dank und herzliche Grüße

Thomas Vollkommer

hallo Thomas,
du kannst in den Eigenschaften des Optionbutton Value auf True setzen.
Diese Einstellung geht aber verloren, wenn beim speichern ein anderer
OptionButton aktiviert ist. In dem Fall gehts per Makro, im Codemodul
DieseArbeitsmappe:

Private Sub Workbook_Open()
Sheets("Tabelle1").OptionButton1.Value = True
End Sub

Gruß
stefan

.



Relevant Pages

  • =?iso-8859-1?q?Re:_Excel_tabelle_an_variable_=FCbergeben?=
    ... dann per optionbutton das Worksheet ... dim ws as worksheet ... Private Sub CommandButton1_Click ...
    (microsoft.public.de.excel)
  • Re: Problem with OptionButton click event
    ... OptionButtons) I do not want tit to trigger the OptionButton click event. ... Private Sub TextBox2203_Change ... If Me.Visible = False Then Exit Sub ... Is there any way to run the code below without triggering the Click Event ...
    (microsoft.public.excel.programming)
  • Re: Problem with OptionButton click event
    ... Normally when I click on OptionButton2201 I want the click event to run, but when I edit TextBox2203 and the code under Else runs I do not want tit to trigger the OptionButton click event. ... Private Sub TextBox2203_Change ... If Me.Visible = False Then Exit Sub ... Dim BlkProc as boolean ...
    (microsoft.public.excel.programming)
  • Re: Change event
    ... I've taken the simpler route of creating a procedure to trap changes to each OptionButton; however, I'm going to hold onto to your code and will include it as I refine my "solution." ... Sub SendOptionButton ... Private Sub UserForm_Initialize ...
    (microsoft.public.excel.programming)
  • Re: Hidding buttons
    ... Private Sub Worksheet_Calculate ... 'based on typing in A1 ... (Is it an optionbutton from the Forms ...
    (microsoft.public.excel.programming)