+ Reply to Thread
Results 1 to 3 of 3

select cell based on combobox value

  1. #1
    Registered User
    Join Date
    05-28-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    2

    select cell based on combobox value

    Is there any kind soul out there to guide me how I can use vba to select a cell based on my combobox value.

    The selected cell has same value as the combobox value

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: select cell based on combobox value

    You need to post a sample of your data and what you are trying to acheive.



    sample is attached.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-28-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: select cell based on combobox value

    Thanks Mehmetcik, its something i need, but without the userform. I have done it around by using data validation and did a search on the data validation cell follow by a range(cell).select.
    Nonetheless, is it still possible to use combo box within the excel sheet with the same effect?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to Select Worksheet and Cell/range based on ComboBox Values
    By ckarlest in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2014, 10:54 AM
  2. [SOLVED] Display in Listbox,based on combobox select the spare cards history
    By Mikebau in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2013, 06:05 PM
  3. [SOLVED] Select Range based on COmboBox selections
    By cmore in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2013, 11:24 PM
  4. [SOLVED] Excel Userform: Populate other controls (i.e. textbox & combobox) based on combobox select
    By MileHigh_PhD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2013, 04:50 PM
  5. Select a worksheets based on combobox value
    By danaas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2012, 03:52 AM

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