Solved

Excel VBA display value of control in a form. (Easy)

Posted on 2014-01-30
5
341 Views
Last Modified: 2014-01-31
I have a spreadsheet with a form frmDemo that has a control called cboPeriod.


1. How do I msgbox a control in this form called cboPeriod??

2. How do I set sheet1 cell A1 is cboPeriod?
0
Comment
Question by:Patrick O'Dea
  • 3
  • 2
5 Comments
 
LVL 46

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 39822878
1. What do you mean when you say "How do I msgbox a control..."?

2.Worksheets("Sheet1").Cells(1,1).Value = frmDemo.cboPeriod.Text
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 39822881
1. Maybe MasgBox frmDemo.cboPeriod.Text
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 39823288
That's it !

Thanks
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 39824030
You're welcome and I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2013
0
 

Author Comment

by:Patrick O'Dea
ID: 39824081
Thanks Marty... I will read later.


I read your profile ....
Your years in the business surpasses mine (but not by that much!).
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Paste different types of data (chart, table, image, etc) onto one page? 4 25
MS excel check if Links exist 5 35
Excel IF formula 3 19
Merging spreadsheets 8 34
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question