Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding conditional rows
Hello, I want to be able to have rows/cells generated with a certain text
based on the answer given by a user. For example, My question in a cell could be "how many groups have you made?". Now to this if the user answers "3" then I would want three cells below to ask "what is the name of your first group", "what is the name of your second group" and so on. Based on this further questions could be asked. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding conditional rows
Have a look in vba help index for INPUTBOX
-- Don Guillett SalesAid Software "Deepak Varde" <Deepak wrote in message ... Hello, I want to be able to have rows/cells generated with a certain text based on the answer given by a user. For example, My question in a cell could be "how many groups have you made?". Now to this if the user answers "3" then I would want three cells below to ask "what is the name of your first group", "what is the name of your second group" and so on. Based on this further questions could be asked. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding conditional rows
As a astarter
Sub Macro1() Dim ans Dim i As Long Dim sName As String ans = InputBox("How many groups have you made") If ans < "" Then ActiveCell.Offset(1, 0).Resize(3).Insert For i = 1 To ans sName = InputBox("What is the name of group #" & i) ActiveCell.Offset(i, 0).Value = sName Next i End If End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" <Deepak wrote in message ... Hello, I want to be able to have rows/cells generated with a certain text based on the answer given by a user. For example, My question in a cell could be "how many groups have you made?". Now to this if the user answers "3" then I would want three cells below to ask "what is the name of your first group", "what is the name of your second group" and so on. Based on this further questions could be asked. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding conditional rows
Hello Bob,
Can I do this without the VB? I dont know how to program macros or any form of VB. I was looking more towards understanding the concept and then applying. If there is no way then I would try and understand the solution that you've provided. "Bob Phillips" wrote: As a astarter Sub Macro1() Dim ans Dim i As Long Dim sName As String ans = InputBox("How many groups have you made") If ans < "" Then ActiveCell.Offset(1, 0).Resize(3).Insert For i = 1 To ans sName = InputBox("What is the name of group #" & i) ActiveCell.Offset(i, 0).Value = sName Next i End If End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" <Deepak wrote in message ... Hello, I want to be able to have rows/cells generated with a certain text based on the answer given by a user. For example, My question in a cell could be "how many groups have you made?". Now to this if the user answers "3" then I would want three cells below to ask "what is the name of your first group", "what is the name of your second group" and so on. Based on this further questions could be asked. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding conditional rows
Not really. You might be able to get some way with conditional
formulae/formatting, but not for the sort of flexibility that you seek. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" wrote in message ... Hello Bob, Can I do this without the VB? I dont know how to program macros or any form of VB. I was looking more towards understanding the concept and then applying. If there is no way then I would try and understand the solution that you've provided. "Bob Phillips" wrote: As a astarter Sub Macro1() Dim ans Dim i As Long Dim sName As String ans = InputBox("How many groups have you made") If ans < "" Then ActiveCell.Offset(1, 0).Resize(3).Insert For i = 1 To ans sName = InputBox("What is the name of group #" & i) ActiveCell.Offset(i, 0).Value = sName Next i End If End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" <Deepak wrote in message ... Hello, I want to be able to have rows/cells generated with a certain text based on the answer given by a user. For example, My question in a cell could be "how many groups have you made?". Now to this if the user answers "3" then I would want three cells below to ask "what is the name of your first group", "what is the name of your second group" and so on. Based on this further questions could be asked. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding conditional rows
thank you bob, your help was indeed very useful. Now could you pls tell me,
what reading material should I refer to, to understand programming macros? "Bob Phillips" wrote: Not really. You might be able to get some way with conditional formulae/formatting, but not for the sort of flexibility that you seek. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" wrote in message ... Hello Bob, Can I do this without the VB? I dont know how to program macros or any form of VB. I was looking more towards understanding the concept and then applying. If there is no way then I would try and understand the solution that you've provided. "Bob Phillips" wrote: As a astarter Sub Macro1() Dim ans Dim i As Long Dim sName As String ans = InputBox("How many groups have you made") If ans < "" Then ActiveCell.Offset(1, 0).Resize(3).Insert For i = 1 To ans sName = InputBox("What is the name of group #" & i) ActiveCell.Offset(i, 0).Value = sName Next i End If End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" <Deepak wrote in message ... Hello, I want to be able to have rows/cells generated with a certain text based on the answer given by a user. For example, My question in a cell could be "how many groups have you made?". Now to this if the user answers "3" then I would want three cells below to ask "what is the name of your first group", "what is the name of your second group" and so on. Based on this further questions could be asked. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding conditional rows
Deepak,
Try starting here 'Getting Started With Macros And User Defined Functions' at: http://www.mvps.org/dmcritchie/excel/getstarted.htm You might also look at David's tutorials page at: http://www.mvps.org/dmcritchie/excel....htm#tutorials -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" wrote in message ... thank you bob, your help was indeed very useful. Now could you pls tell me, what reading material should I refer to, to understand programming macros? "Bob Phillips" wrote: Not really. You might be able to get some way with conditional formulae/formatting, but not for the sort of flexibility that you seek. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" wrote in message ... Hello Bob, Can I do this without the VB? I dont know how to program macros or any form of VB. I was looking more towards understanding the concept and then applying. If there is no way then I would try and understand the solution that you've provided. "Bob Phillips" wrote: As a astarter Sub Macro1() Dim ans Dim i As Long Dim sName As String ans = InputBox("How many groups have you made") If ans < "" Then ActiveCell.Offset(1, 0).Resize(3).Insert For i = 1 To ans sName = InputBox("What is the name of group #" & i) ActiveCell.Offset(i, 0).Value = sName Next i End If End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" <Deepak wrote in message ... Hello, I want to be able to have rows/cells generated with a certain text based on the answer given by a user. For example, My question in a cell could be "how many groups have you made?". Now to this if the user answers "3" then I would want three cells below to ask "what is the name of your first group", "what is the name of your second group" and so on. Based on this further questions could be asked. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding conditional rows
Thank you Bob. Thanks a million.
"Bob Phillips" wrote: Deepak, Try starting here 'Getting Started With Macros And User Defined Functions' at: http://www.mvps.org/dmcritchie/excel/getstarted.htm You might also look at David's tutorials page at: http://www.mvps.org/dmcritchie/excel....htm#tutorials -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" wrote in message ... thank you bob, your help was indeed very useful. Now could you pls tell me, what reading material should I refer to, to understand programming macros? "Bob Phillips" wrote: Not really. You might be able to get some way with conditional formulae/formatting, but not for the sort of flexibility that you seek. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" wrote in message ... Hello Bob, Can I do this without the VB? I dont know how to program macros or any form of VB. I was looking more towards understanding the concept and then applying. If there is no way then I would try and understand the solution that you've provided. "Bob Phillips" wrote: As a astarter Sub Macro1() Dim ans Dim i As Long Dim sName As String ans = InputBox("How many groups have you made") If ans < "" Then ActiveCell.Offset(1, 0).Resize(3).Insert For i = 1 To ans sName = InputBox("What is the name of group #" & i) ActiveCell.Offset(i, 0).Value = sName Next i End If End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" <Deepak wrote in message ... Hello, I want to be able to have rows/cells generated with a certain text based on the answer given by a user. For example, My question in a cell could be "how many groups have you made?". Now to this if the user answers "3" then I would want three cells below to ask "what is the name of your first group", "what is the name of your second group" and so on. Based on this further questions could be asked. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding conditional rows
Dear Bob,
In the solution provided by you, how do I assign a perticular cell to capture/store the user inputs from the questions answered in the inputbox Regards, Deepak "Deepak Varde" wrote: Thank you Bob. Thanks a million. "Bob Phillips" wrote: Deepak, Try starting here 'Getting Started With Macros And User Defined Functions' at: http://www.mvps.org/dmcritchie/excel/getstarted.htm You might also look at David's tutorials page at: http://www.mvps.org/dmcritchie/excel....htm#tutorials -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" wrote in message ... thank you bob, your help was indeed very useful. Now could you pls tell me, what reading material should I refer to, to understand programming macros? "Bob Phillips" wrote: Not really. You might be able to get some way with conditional formulae/formatting, but not for the sort of flexibility that you seek. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" wrote in message ... Hello Bob, Can I do this without the VB? I dont know how to program macros or any form of VB. I was looking more towards understanding the concept and then applying. If there is no way then I would try and understand the solution that you've provided. "Bob Phillips" wrote: As a astarter Sub Macro1() Dim ans Dim i As Long Dim sName As String ans = InputBox("How many groups have you made") If ans < "" Then ActiveCell.Offset(1, 0).Resize(3).Insert For i = 1 To ans sName = InputBox("What is the name of group #" & i) ActiveCell.Offset(i, 0).Value = sName Next i End If End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" <Deepak wrote in message ... Hello, I want to be able to have rows/cells generated with a certain text based on the answer given by a user. For example, My question in a cell could be "how many groups have you made?". Now to this if the user answers "3" then I would want three cells below to ask "what is the name of your first group", "what is the name of your second group" and so on. Based on this further questions could be asked. |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding conditional rows
Deepak,
Do you understand how to use variables? I ask as I showed you that first post up, but I think you may not have understood. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" wrote in message ... Dear Bob, In the solution provided by you, how do I assign a perticular cell to capture/store the user inputs from the questions answered in the inputbox Regards, Deepak "Deepak Varde" wrote: Thank you Bob. Thanks a million. "Bob Phillips" wrote: Deepak, Try starting here 'Getting Started With Macros And User Defined Functions' at: http://www.mvps.org/dmcritchie/excel/getstarted.htm You might also look at David's tutorials page at: http://www.mvps.org/dmcritchie/excel....htm#tutorials -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" wrote in message ... thank you bob, your help was indeed very useful. Now could you pls tell me, what reading material should I refer to, to understand programming macros? "Bob Phillips" wrote: Not really. You might be able to get some way with conditional formulae/formatting, but not for the sort of flexibility that you seek. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" wrote in message ... Hello Bob, Can I do this without the VB? I dont know how to program macros or any form of VB. I was looking more towards understanding the concept and then applying. If there is no way then I would try and understand the solution that you've provided. "Bob Phillips" wrote: As a astarter Sub Macro1() Dim ans Dim i As Long Dim sName As String ans = InputBox("How many groups have you made") If ans < "" Then ActiveCell.Offset(1, 0).Resize(3).Insert For i = 1 To ans sName = InputBox("What is the name of group #" & i) ActiveCell.Offset(i, 0).Value = sName Next i End If End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Deepak Varde" <Deepak wrote in message ... Hello, I want to be able to have rows/cells generated with a certain text based on the answer given by a user. For example, My question in a cell could be "how many groups have you made?". Now to this if the user answers "3" then I would want three cells below to ask "what is the name of your first group", "what is the name of your second group" and so on. Based on this further questions could be asked. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use conditional formatting to hide or delete rows? | Excel Worksheet Functions | |||
Adding and Deleting rows - update formulas help needed. | Excel Worksheet Functions | |||
Adding and deleting rows with formulas ****Need Help**** | Excel Discussion (Misc queries) | |||
Adding summaries, rows and pre-population | New Users to Excel | |||
Adding Rows to Master Sheet | New Users to Excel |