+ Reply to Thread
Results 1 to 3 of 3

Need Help On Listbox/combobox

  1. #1
    Registered User
    Join Date
    06-24-2005
    Posts
    45

    Question Need Help On Listbox/combobox

    I am trying to automate some of the manual tasks .I am progressing very well with that with help of this forum. Most of the samples I took from this site. Currently I am having difficulty in creating a listbox or Combobox in spreadsheet using programmatically (Dynamic).

    Requirement is that if I click a button then it shoud create a new workbook and in Sheet1 and in Column 1 and in first 10 cells(a1,a2,a3,a4,a5,a6,a7,a8,a9,a10) , I need create a LISTBOX (MAY BE i AM REFERING A DROP DOWN BOX IN each CELL) having Foloowing values.
    1-Workrequest
    2-Problemstudy
    3-Recovery
    4-Other

    I tried to find out the similar topics in this site and coul dnot found. It would be appreciated , if somebody could help me to guide me,

    Joe
    Last edited by joe12613; 08-28-2007 at 04:33 PM.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    This code might get you where you need to go:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-24-2005
    Posts
    45

    Thanks...........

    Thanks you very much ...It worked !!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1