Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms and Checkboxes
This is copied from a question i put in the discussion group excel general
which i think was the wrong group.Apoloies if this was ot the correct thing to do I am new to VBA and am trying to do the following, I have created the Userform and check boxes but that is as far as i have got. When a ceratin a cell e.g A1 goes to = red then a userform will pop up with a list of check boxes e.g Nexus, G2, Swift, Crest if Nexus and Crest check box is ticked then the word nexus will appear A2 and Crest in A3. Or if G2 and Swift were checked then G2 would be in cell A2 and Swift in cell C3. Many Thanks Simon Jelinek |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms and Checkboxes
hi Jelinek
Read this http://support.microsoft.com/default...b;EN-US;829070 You can use a event in the sheet module to open the userform See this page for more information http://www.cpearson.com/excel/events.htm Like this Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Range("a1"), Target) Is Nothing Then If Target.Value = "red" Then UserForm1.Show End If End Sub You can add a button on your userform that check the value of the checkboxes Private Sub CommandButton1_Click() If Me.CheckBox1.Value = True Then Range("B1").Value = "Hi" End Sub If you need more help post back -- Regards Ron de Bruin http://www.rondebruin.nl "Jelinek" wrote in message ... This is copied from a question i put in the discussion group excel general which i think was the wrong group.Apoloies if this was ot the correct thing to do I am new to VBA and am trying to do the following, I have created the Userform and check boxes but that is as far as i have got. When a ceratin a cell e.g A1 goes to = red then a userform will pop up with a list of check boxes e.g Nexus, G2, Swift, Crest if Nexus and Crest check box is ticked then the word nexus will appear A2 and Crest in A3. Or if G2 and Swift were checked then G2 would be in cell A2 and Swift in cell C3. Many Thanks Simon Jelinek |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Userforms | Excel Discussion (Misc queries) | |||
UserForms | Excel Discussion (Misc queries) | |||
checkboxes on userforms | Excel Programming | |||
Userforms | Excel Programming | |||
userforms | Excel Programming |