Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlink - cell population
I'd put two little buttons from the Forms toolbar in adjacent cells and click on
them. Assign each this macro: Option Explicit Sub testme01() Dim myBtn As Button Dim myCell As Range With ActiveSheet Set myCell = .Range("b1") Set myBtn = .Buttons(Application.Caller) If myBtn.TopLeftCell.Row = 1 Then myCell.Value = myCell.Value & "C" Else myCell.Value = myCell.Value & "D" End If End With End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Stu wrote: I have a spread sheet that has descriptions and a letter or number next to them. Example: A1 B1 cat C dog D I want to be able to click on cat and populate cell C1 with the letter C and I want to be able to click on dog and populate cell C1 with the letter D consectivly, so if I clicked on cat then dog cell C1 would contain "CD", if i clicked on dog then cat cell C1 would contain "DC"....how can I do this in excell with a link or is there a better way to make it work? thanks, Stu -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink auto-population? Please Help | Excel Worksheet Functions | |||
cell auto population - why 0 when source cell is empty? | Excel Discussion (Misc queries) | |||
Cell Population based on a Table | Excel Discussion (Misc queries) | |||
Can I have automatic cell population while using combo list? | Excel Discussion (Misc queries) | |||
Automatic cell population | Excel Discussion (Misc queries) |