TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Dinesh Santhalingam
NA
737
368.4k
Add a Combo Box in a Excel cell Using VBA
May 8 2017 5:40 AM
Set
objGEXCELapp
=
GetObject
(, "EXCEL.Application")
If Err.Number
<
>
0 Then
Err.Clear
Set
objGEXCELapp
=
CreateObject
("EXCEL.Application")
End If
objGEXCELapp.Application.Visible
=
True
Set
objGEXCELwkBks
=
objGEXCELapp
.Application.Workbooks
Set
objGEXCELwkBk
=
objGEXCELwkBks
.Add
Set
objGEXCELwkShs
=
objGEXCELwkBk
.Worksheets(1)
Set
objGEXCELSh
=
objGEXCELwkBk
.Sheets(1)
objGEXCELSh.Cells(1, "A") = "Name"
objGEXCELSh.Cells(1, "B") = "Age"
objGEXCELSh.Cells(1, "C") = "Weight"
objGEXCELSh.Cells(1, "D") = "Height"
objGEXCELSh.Cells(1, "E") = "Sex"
objGEXCELSh.Cells(1, "F") = "Your Option"
objGEXCELSh.Cells(i, "A") = Dhini
objGEXCELSh.Cells(i, "B") = 22
objGEXCELSh.Cells(i, "C") = 73
objGEXCELSh.Cells(i, "D") = 165
objGEXCELSh.Cells(i, "E") = Male
objGEXCELSh.Cells(i, "F") = Here I need a Combobox to occupy in a cell to select
I need a combobox in my cell .Please give me a solution.
Reply
Answers (
1
)
I want some Extension of file from a selected folder in VBA?
any one can explain delegate in c# using real time example?