Display Cell Content To User & Act On Their Response

Oct 5, 2006

In which control of vba can I show output of my work to a user of the program? But there is a trick here. In the output form, I need to ask something to the user so that I can proceed. (I need to put a few labels and a text box in the output form)

View 9 Replies


ADVERTISEMENT

Dropdown List With User Response Type-in

May 18, 2007

I know how to create a basic dropdown list, but what I don't know (I don't even know if it is possible to do at all) is how to allow user type-in response if the "Other (please specify)" option is used.

Column A
Question 1. What type of report are you using?
Column B will contain

Type I Report
Type II Report
Other (please specify)

If Type I or II is chosen from the list, I don't want user to be able to change anything. But If the Other (please specify) option is selected I would like to give user an ability to type in type of the report he/she is using. Also, is there a way to have list options chosen based on another list response?

View 2 Replies View Related

Tricky Dynamic List - Allow User To Specify A GROUP And RESPONSE ID?

Mar 17, 2014

I have a list of items in column A ("Questions"). Let's use 3 for this example.

I have seven respondent GROUPS, represented by a column.At the intersection of each QUESTION and each GROUP, a number appears, indicating the most popular answer to that question expressed as a number from 1-6, or BLANK if no response was the most popular answer.So the data looks like this:

Group1
Group2
Group3
Group4
Group5
Group6
Group7

Q1text
1
5
5
3

[Code] .....

Now... the part that will seem upside down...I want this sheet to allow the user to specify a GROUP and a RESPONSE ID (1-6) to produce a LIST of QUESTIONS that will be used as the contents of a dynamic dropdown.For example, if the user selected GROUP6, RESPONSE4, I'd like the dropdown to contain:

Q1Text
Q4Text

If the user selected GROUP1, RESPONSE1, I'd like the dropdown to contain:

Q2Text
Q4Text

It is not possible for the RESPONSE selection to be "Blank", though blanks do appear amongst responses.

I can't get solutions to switch dynamically based on the selected GROUP.

View 4 Replies View Related

Hide Content Of Cell So It Appears Blank To User?

Jan 26, 2014

I would like to hide the content of a cell so it appears blank to user. I edit excel bike tour (route) cue sheets for our bicycle club and some info is needed for formulas in calculating total distance but doesn't need to be seen by the bicycle rider.

View 5 Replies View Related

Formula That Will Look For Keywords And Display Cell Content?

Sep 23, 2011

is it possible to have a formula that will look for keywords and display the cell content?

View 2 Replies View Related

Display Image Based On Cell Content

Aug 17, 2007

I'm trying to display a different image based on the contents of a cell. For example if cell A1 = "Gerrard" I would then like to display a picture of Steven Gerarrd. Is this possible? If so can anyone give me a steer in how I might acheive this.

View 3 Replies View Related

Display A List Of Cell Entries, Allow The User To Select Which To Delete

Sep 16, 2009

Hoping someone would be able to help me with this. I have a sheet (example attached) and this sheet has a number of varying description types in the W coloumn (usually approx 10,000 rows). This field is manually input so there could be spelling mistakes and/or non standard descriptions.

What I would like, if possible, is a macro that would look at the D column and if this is 'GENERAL LEDGER', it would then look at the W column.

An input box would come up, and would list the different descriptions it found in column W, and number them. It would only list each different description once.

e.g.

1. Bank charges
2. Bank charge
3. Cash
4. Fund Custodian Fees
5. Fund Manager fee
6. Interest income cash account
7. Interest income cash acc
8. Miscellaneous expenses
9. Miscellaneous income
10. Other income
11. Sec lending comm
12. Sec lending commission income
13. Tax Reclaimable - Dividends
14. Withholding tax dividend

The user would then be able to type in the corresponding numbers, if possible seperated by a space, comma or semicolon and the macro would then run through the sheet and delete the entire row if D was GENERAL LEDGER and W was the selected description.

View 9 Replies View Related

Read Cell Content & ADD Content + Font Properties *SOLVE

Sep 12, 2007

I use this to read cell content, add some text/characters (ie. [ and ]) and change the properties of the complete cell

Sub COMMENT()
Worksheets("DVD Lijssie").Activate
If ActiveCell.Value 0 Then ' Change all in to ... ... ...
ActiveCell.FormulaR1C1 = ActiveCell.Value & " " & "]" & " " & "["
With ActiveCell.Font
.Name = "Arial Narrow"
.Size = 8
.ColorIndex = 16
End With
End If
End Sub
HOW can I change this vba-code so it leave's the content of the cell like it is and add some content with the use of let's say TexBox1 and ONLY use different font properties for the newely added content?

View 9 Replies View Related

Initiating A Response When Entering Into A Cell

Mar 20, 2008

I have an Excel worksheet that when a user enters something into cell A1 I want to clear cells (b2:b20). If I use an object, I can attach a macro to it, but I don't want to use an object. I want to use an Excel cell and then when the user types into it, I want to perform an action.

View 9 Replies View Related

Change Content Of One Cell Based On Content Of Another

Apr 18, 2014

Formula/macro/etc that would enable me to have content of a cell changed based on the content of another cell in the same row.

Example: cell in column D says "PSA" - so I would need the cell in column H for that same row to read "Radio"

I would need an entire sheet scanned to review for these occurrences and make the appropriate changes. I also would need the formula to be inclusive enough to scan for variations in column D cell content (PSA 1, PSA 2, etc).

View 4 Replies View Related

Display FileSystemObject To User

Apr 7, 2006

I want to display a control to the user so they can select a folder. I'm assuming that the proper control would be the FileSystemObject.

If that assumption is correct, I would think the first part of the code would be something like:

Dim fso As Scripting.FileSystemObject
Set fso = New Scripting.FileSystemObject

View 9 Replies View Related

User Friendly Way To Display Range Value

Jul 14, 2009

I am writing a macro in which the user selects several ranges (entire columns) for the macro to manipulate. I display a userform to the user that contains 16 refedit objects (1 for each range that they picked). Unfortunately, the value that appears in the refedit boxes is not very user-readable. It looks like this:

'[WorkBookName.XLS]Sheet1'!$B$5

I can assume that all of the ranges will reside in the same workbook, so I have been cutting the workbook name portion off as a string and displaying it in 1 place only. I can leave the value of the refedit as: Sheet1'!$B:$B, but even that is not very friendly. Of course if I do change the value of the refedit controls then I will need to "fix" them before attempting to access the range.

Does anyone have a suggestion as to how to display the sheet and column of the range to the user?

View 6 Replies View Related

Matrix - Identify Cell Content In Column For Row If Matrix Content True?

Mar 21, 2014

For a table like the one below produced for the sake of example (actual is much much bigger) I want to make it list rows that are true for a certain column for a certain variable in the matrix. So for say water terrain, which types of activity can I do i.e. swimming. Or for Offroad the activites which I can't do i.e. Run and Swim.

ActivityWaterRoadOffroad
Jog nym
Run nyn
Walk nyy
Swim ynn
y=yes
n=no
m=maybe

View 10 Replies View Related

Display File Open For User To Choose

May 24, 2009

I have code (below) that works if the range "ImportFile2" contains a valid value but I want users to be able to select any .csv file preferably from a directory which should be held in a cell.

I added ...

View 9 Replies View Related

Active Hyperlink Display On User Form

Jul 7, 2006

I have a Excel database and a userform to look-up reocrds. I want to be able to connect a Data Sheet which is a PDF file to every product in the daatbase.

I have created an additional column and created hypelinks in front of each product. these hyperlinks are connected to the datasheet of that product which is saved on the drive.

I have created a field on the userform to display the respective hyperlink when a record is searched by user.

My problem is that the user form displays the hyperlink name, but its dead.
I want users to be able to click on the hyperlink to view the attached Datasheet. I have tried using Textbox and labels to display this hyperlink,

View 6 Replies View Related

Display Selected Cells Depends On User Input?

Jul 17, 2013

I am trying to display number of lines which depends on value pass by user. Actually user is passing some value. on which some group of lines has to be display.

eg
for 1 value 9 lines
for 2 value first 9 lines + another 9 lines
for 3 value first 18lines + 9 lines
and so on till 52.(this 9 lines are set of some column and rows)

thus cant use macros..

View 1 Replies View Related

Userform To Display Range And Populate User Input

Jan 9, 2013

I have a few questions here.

1) Can a userform procedure be place in the midst a larger macro, so that it can get input from the user before running the rest of the macro? ie If the user leave the input field blank, the macro will exit will a msgbox.

2) I have a range(A1:A3) that i want my userform to display. This range is dynamic. The user will require to input the corresponding country next to it. how do i code the this? I will need to use a listboxes and textboxes right?

for example: userform shows city on the left, user will need to input the country on the right.

A1 - California (user input on the right)
A2 - Shanghai (user input on the right)
A3 - Mumbai (user input on the right)

View 1 Replies View Related

Display Number Of Lines Which Depends On Value Pass By User

Jul 17, 2013

I am trying to display number of lines which depends on value pass by user. Actually user is passing some value. On which some group of lines has to be display.

E.g.
for 1 value 9 lines
for 2 value first 9 lines + another 9 lines
for 3 value first 18lines = 9 lines
and so on till 52.

View 2 Replies View Related

User Form That Will Display The Results From A Lookup Formula

Apr 23, 2008

I would like to create a user form that will display the results from a lookup formula. The userform would have 2 textboxes, so from the formula below BZ109 would be textbox1 and CA109 textbox2. Once data is entered in these textboxes you would hit submit to return the results in a message box. What would the code be for the sumbit button?

=VLOOKUP(BZ109, INDIRECT(CA109), 11, 0)

View 9 Replies View Related

Display Popup When User Picks Item From List

Dec 6, 2007

I have a group of validation list boxes, all with the same choices, that when a user selects a certain item from them I want a popup box with extra info in it to appear. Is it possible for the user to click on the popup box once to make it disappear again?

View 6 Replies View Related

Display Server Message To User After POST File Upload

Feb 6, 2014

I'm using VBA to upload the open workbook to app.box URL which is working great! Since I'm pretty new to VBA, I can't figure out how to get Excel to display the sucess/failed message from the server to the user. I used the VBA POST upload module from this awesome tutorial, but I can't figure out how to return the message to the user. I did figure out that on the website there is an "id="after_upload_message", not sure if that works. My code is below.

[Code] ......

View 2 Replies View Related

Cell B1 To Display True If Any Of The Values In Column C Match Otherwise I Want To Display FalseOR Function Confusion

Dec 16, 2008

Example:....

i m wanting Cell B1 to display true if any of the values in column C match otherwise I want to display false.

A 1
B 0
C 0
D 0

But I can't determine how to get this done.

View 5 Replies View Related

VBA / Word Picture Content Control Causing Unreadable Content?

Jan 15, 2013

I am using VBA to create a word document (.docx). This word document contains plain text content controls as well as picture content controls. I then use VBA to automatically select a picture based on the code below

Code:
Set oCC = Word.ActiveDocument.SelectContentControlsByTitle("TabPic").Item(1)
On Error GoTo TabErrorHandler
oCC.Range.InlineShapes.AddPicture Filename:="X:XFERANDREW-TDCD " & LblVL &

[Code].....

After the document has been closed down I try to open it again and I am told "The file cannot be opened because there are problems with the contents."

When I click details it says "Unspecified error" and "Location: Part: /word/document.xml, Line: 2, Column: 0"

If I click ok it says "Word found unreadable content in "". Do you want to recover the contents of this document? If you turst the source of this document, click Yes.

Clicking Yes opens the document with all the contents and it is now renamed to Document 1. If I click no it does not open.

View 9 Replies View Related

Merge The Content Of 2 Cells Into 1 (with A Comma Separating The Content)

Jan 29, 2007

how to combine the content of 2 cells into one cell and have the information separated by a comma.

For example:

CELL 1:
Software 1

CELL 2:
Spreadsheet Software

The desired results is:

CELL 3:
Software 1, Spreadsheet Software

View 3 Replies View Related

Msg Box Response Is Ignored

Apr 26, 2009

I am trying to achieve a response from a msgbox which will either continue with the sub or exit. I think my code is right but it doesn't seem to work and just carrys on regardless.

View 6 Replies View Related

Response Log

Dec 17, 2007

I'm trying to find a formula I can use to figure response time. The working hours are 7:00 AM to 3:00 PM and I do not want to count the hours between 3:00 pm and 7:00 AM of the next day.

Example:

Cell A1 has the call in DATE 12/06/07 and cell B1 has the call in time of 10:00 AM.

Cell C1 has the response date of 12/07/07 and cell D1 has the time of 9:00 AM.

So what I need is a formula in cell E1 that would count from 10:00AM untill 3:00 PM on 12/6/07 then pickup the count on 12/07/07 at 7:00 AM and go untill 9:00 AM.

So in this Example the final response time would be 7 hours or 7:00.

View 9 Replies View Related

Select Only One Response

Aug 11, 2008

Trying to accomplish a bit of data validation...

4 cells
A1 B1 C1 D1

The only acceptable input for these cells in a 'x'
If I place an 'x' in any one of the four cells than the other three must be blank.

View 14 Replies View Related

Return A Blank Response

Jan 4, 2009

if cell a24 has nothing in it how can i make sure a77 is blank at the moment it returns a zero

View 2 Replies View Related

IF Formula Response Y Or N In Column

Jan 27, 2009

I would like a formula which will give a Y or N response in Column C.

If there is content in Column A or B the result should be Y.
If Columns A or B are empty the result should be N.

Example 1
Column A = 2
Column B = 0
Column C = Y

Example 2
Column = 0
Column = 0
Column = N

View 2 Replies View Related

Getting Formula To Remove 0 Response

Dec 14, 2012

I have this formula: =(CONCATENATE(COUNT('Master Report'!R8:R34)," ",IF(COUNT('Master Report'!R8:R34)>0,"Departments are over Action OI 50%","")))

when there is nothing to count, it places a 0. I want to to be blank. How can I achieve this.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved