473,385 Members | 1,400 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Return Cell Location from Combo Box

Hi,

I have created a user form, which has various combo box's on which have been linked to an Excel Worksheet. What i want to do is select a item from a combobox (This would correspond to Cell A1 on my workseet) In a separate box i would like it to return the value which is located, in the same worksheet and row, but in a different column (for Example A7). Whats the Best way of Doing this????

Any Help would be most appreciated

Manny
Dec 1 '06 #1
0 924

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: jack | last post by:
I'm using VBA for Excel and would like to do the following: 1) in sheet1, search for a value which is given in a specific cell location on sheet2. 2) when i find that value in sheet1, i want...
1
by: sjebaemer | last post by:
how do i get the value of the combobox cell?
4
by: simon | last post by:
which data control allows me to use a cell doubleClick event? I have time cells (something like Outlook calendar) and when user double click on one cell I would like to redirect to other window...
0
by: Vikram | last post by:
I am changing parent cell of a combo at runtime suing table.rows(1).cells(2).add(cboname) earlier cboname is in cell 0 of row 2, and now i am changung its cell to cell 2 of row 1... But when...
0
by: Venkat | last post by:
Hi, I have developed an application which interacts with the Excel instance and opens the documents etc. My problem is now I want to display a combo box in the cell selected by the user at...
1
by: kjtaylor | last post by:
I want to use the return value of a javascript function into a .net webgrid. However, when I click on the imagebutton it takes in a variable passed in from javascript function to produce the image...
2
by: jit007 | last post by:
HI all , I am creating a UI using VBA program where I am using OWC 11 control. What I want is that--- when user will select the pricular cell(say, D4) in the OWC spreadsheet, a combo box appears...
0
by: shakthisarav | last post by:
Hi, problem: Add one combo to the excel spreadsheet. let it be in cell 'd1'.the combo should contain items as lock & unlock.when we click on lock the cells a1:c1 must be disabled. the cell e1...
1
by: shakthisarav | last post by:
Hi Frnz pls help me in doing the below task ................. problem: Add one combo to the excel spreadsheet. let it be in cell 'd1'.the combo should contain items as lock & unlock.when we...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.