• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 312
  • Last Modified:

Excel VBA programatically place a ComboBox over cell

Hi

In VBA is it possible to programatically place a ComboBox over the cells in Row 1 of the spreadsheet
0
Murray Brown
Asked:
Murray Brown
1 Solution
 
StephenJRCommented:
A forms combo box -
With ActiveSheet.DropDowns.Add(142.5, 38.25, 108.75, 24)
    .Top = Range("C1").Top
    .Left = Range("C1").Left
End With

Open in new window

Or just
ActiveSheet.DropDowns.Add(Range("C1").Left, Range("C1").Top, 108.75, 24).Select

Open in new window

0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks very much
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now